Can anyone please tell how we can export the run time datatable into CSV file.
I tried this
But when i am trying to open this file , it throws an error message that..the file you are trying to open is in another format. How we can get rid of this problem.
May be try to Save the same as a CSV file using excel objects
Winds of Change
You can even open an excel file in csv format.
or you can covert it by code as below:
Const xlCSV = 6
Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open("C:\Scripts\Testsheet.xls" )
objExcel.DisplayAlerts = FALSE
objExcel.Visible = TRUE
Set objWorksheet = objWorkbook.Worksheets("Sheet1")
objWorksheet.SaveAs "c:\scripts\test.csv", xlCSV