Save xls as csv

[felbert]

I have a csv file I am trying to open and then save as a xls. When I change the name, and then tab to the save as type box, the extension changes from .xls to.csv. When I try to change the Save as type box to "Microsoft Office Excel Workbook (*.xls) it changes to .csv.

The reason I am trying to save the .csv as a .xls is because I have a macro I want to run, and it is not available in Excel when a .csv file is open, but only when a .xls is open.

Any suggestions?

Thanks

[forumsupport]

Hello,

You can use 'Insert Keystrokes' command to save CSV file as XLS. For your convenience, we have attached SaveCSVtoXLS.atmn. Copy it under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder. This task converts sections.csv into NewXLSFile.xls. You can edit line #1 in task editor and can select or specify csv file that you want to save as xls.

Hope that helps.

[felbert]

Works great. Thanks