.xlsx to csv
currently i run all my tests from scripts in .csv files. in the future i would prefer maintain my scripts in xlsx do you have some sample code which would allow me to convert an .xlsx to a csv in...
Forum Discussion
Hi Richard,
Try this
Dim oExcel
Dim oBook
Const intCSVFormat = 6
Set oExcel = CreateObject("Excel.Application")
Set oBook = oExcel.Workbooks.Open("[Excel Path]")
oBook.SaveAs "[CSV Path]", intCSVFormat
oBook.Close False
oExcel.Quit
Try this
Dim oExcel
Dim oBook
Const intCSVFormat = 6
Set oExcel = CreateObject("Excel.Application")
Set oBook = oExcel.Workbooks.Open("[Excel Path]")
oBook.SaveAs "[CSV Path]", intCSVFormat
oBook.Close False
oExcel.Quit