| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
can i save an existing .xls file as a .csv file using command line
I have an .xls file that I want to convert to a .csv file using the command
line. Is this possible? |
|
#2
|
|||
|
|||
|
Try this:
ActiveWorkbook.SaveAs Filename:= _ "C:\Documents and Settings\All Users\Desktop\Book1.csv", FileFormat:=xlCSV "craigkan" wrote: I have an .xls file that I want to convert to a .csv file using the command line. Is this possible? |
|
#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\OFFICE11excel.exe filename.xls which will open filename.xls, but i can't figure out how to save this file as .csv "Chad" wrote: Try this: ActiveWorkbook.SaveAs Filename:= _ "C:\Documents and Settings\All Users\Desktop\Book1.csv", FileFormat:=xlCSV "craigkan" wrote: I have an .xls file that I want to convert to a .csv file using the command line. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem viewing existing .XLS file | Excel Discussion (Misc queries) | |||
| Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) | |||
| When converting an .xls file to .csv I get too many commas at the. | Excel Discussion (Misc queries) | |||
| .CSV file format - comma or semi-colon? | Excel Worksheet Functions | |||
| .CSV file format - comma or semi-colon | Excel Worksheet Functions | |||
Linear Mode
