can i save an existing .xls file as a .csv file using command line

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an .xls file that I want to convert to a .csv file using the command
line. Is this possible?
 
Try this:

ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\All Users\Desktop\Book1.csv",
FileFormat:=xlCSV
 
this code does not work from the command line. if i go to my excel directory
i can run C:\Program Files\Microsoft Office\OFFICE11>excel.exe filename.xls
which will open filename.xls, but i can't figure out how to save this file
as .csv
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I change a csv extension file to an xls file and use it? 1
Save as Command Line 1
Convert csv to Excel files 1
Best way to export from Excel to MySQL? 1
save form 2
how to convert .xls to .csv? 1
CSV Tab Delimited 4
Which is the best MBOX Converter Tool different formats conversion? 5

Back
Top