Not working, I have attached the files. Book1.xlsx - original file Book1.csv - csv converted file(open with notepad or Import in SAS you will see only few decimals) Book2.csv - csv converted using VBA code given below( same problem as above) Sub vba_code_to_convert_excel_to_csv() Set wb = Workbooks.Open("C:\Users\1307608\Desktop\Book1.xlsx") wb.SaveAs Filename:="C:\Users\1307608\Desktop\Book2.csv", FileFormat:=xlCSV, CreateBackup:=False End Sub
... View more