Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I need to create CSV file...
but the same way as I did for excel using CREATEOBJECT("EXCEL.APPLICATION")
Set XLApp=CREATEOBJECT("EXCEL.APPLICATION")
So how can I use CreateObject to Create CSV files..
Regards
Avadhoot
You don't need to create an application object to export to csv. Just use the Export member:
Sub ExportToCSV
set obj= ActiveDocument.GetSheetObject("CH01")
obj .Export "C:\File.csv", ", "
End Sub