Thread: Save As Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Roy Roy is offline
external usenet poster
 
Posts: 53
Default Save As Macro

I often load CSV files into Excel and then re-save them as Excel Workbooks
(*.xls) format. The loading of the CSV file is handled by a command-line
that invokes Excel and loads the CSV.

After the CSV is loaded into Excel it would be VERY nice if a macro could be
executed that would then save the CSV in XLS format, instead of doing the
SAVE As manually.

Suggestions would be welcome.