xls to csv automated conversion

robinbrown8636

New Member
Joined
Nov 21, 2005
Messages
2
I am looking for an automated way to convert .xls files into csv. Convertion should be launched from .bat file. thanks for any help
 

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
This batch file (typed in Notepad and saved with .BAT suffix) will run Excel and open Book1.xls

--------------------------------------------------------------
C:
CD \PROGRAM FILES\MICROSOFT OFFICE\OFFICE
EXCEL C:\TEMP\BOOK1.XLS
'--------------------------------------------------------------

I would record a macro and set it to autorun when the workbook is opened using Private Sub Workbook_Open()
 

robinbrown8636

New Member
Joined
Nov 21, 2005
Messages
2
Brian,
thanks for the quick response. I should have noted that my conversion from xls to csv has to happen without user interaction. The batch file would run at night and convert the xls to csv and then ftp the csv file to unix.
thanks again
Robin Brown
 

Forum statistics

Threads
1,077,782
Messages
5,336,284
Members
399,074
Latest member
rlong98

Some videos you may like

This Week's Hot Topics

Top