excel to csv

[b00gieman]

Hi!
Dunno if this is the right place to ask,but....can somebody recommend a good script for transforming excel files into csv files?

Thanks in advance!

 

[Microbe]

I reckon if you open the Excel file and then save as CSV that would do it.

Steve Davis

http://www.HaHaHa.com.au/weblog

NOTE: This sig does not include any reference to voting, stars, or marking posts as helpful as doing so is cause for membership termination.

 

[b00gieman]

I know that,but I thought I could automatize that.

 

[Microbe]

you can to it with VB

Dim objXL As Object, x
Set objXL = CreateObject("Excel.Application")
With objXL.Application
.displayalerts = False
.Visible = True
.workbooks.Open "your excel file's path.xls"
.workbooks("your excel file's name").SaveAsFileName:="path and name of your csv file.csv"
.workbooks("path and name of your csv file.csv").Close , savechanges:=True
End With
objXL.Quit
Set objXL = Nothing

Steve

http://www.ColdCallComedy.com