How do i open excel file and save as csv in VB

[Itopa]

I want to open an excel file and then save as csv. Pls how do i using vb 6

 

[JAG14]

Honestly I don't know how to connect to Excel through VB6 but I figured that this may help you if you can get round to using VBA within Excel.

ThisWorkBook.SaveAs FileFormat:=xlCSV, Filename:="C:\MyBook.CSV"

Maybe there is a way to do the same thing from within VB6.

Hope it helps,

[tt]'Very funny, Scotty... Now Beam down my clothes.'[/tt]
​

 

[shakespeare5677]

'declare excel app object
Dim exl As New Excel.Application
'open the file
exl.Workbooks.Open "c:\somefile path..."
'save csv
exl.Workbooks(1).SaveAs "c:\newfile path...", xlCSV
'close
exl.Workbooks(1).Close False
'quit excel
exl.Quit
'clear
set exl = nothing

-Max

 

[ClulessChris]

If you just whant to change the file type and not open the file you could use the name as method:

Name SomeFilePath\Excel.xls AS SomeFilePath\Excel.CSV

Everybody body is somebodys Nutter.

 

[johnwm]

Renaming a .XLS file as a .CSV file will just create a mess! There have been several discussions on Excel & VB (see Search tab above) but you could start with faq222-3383

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller