I have an .xls file that I want to convert to a .csv file using the command line. Is this possible?
C craigkan Feb 17, 2005 #1 I have an .xls file that I want to convert to a .csv file using the command line. Is this possible?
C Chad Feb 17, 2005 #2 Try this: ActiveWorkbook.SaveAs Filename:= _ "C:\Documents and Settings\All Users\Desktop\Book1.csv", FileFormat:=xlCSV
Try this: ActiveWorkbook.SaveAs Filename:= _ "C:\Documents and Settings\All Users\Desktop\Book1.csv", FileFormat:=xlCSV
C craigkan Feb 18, 2005 #3 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
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
