Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Convert XLS to CSV : Code not working
The link shows to comvert excel to CSV. But I need a script to convert .CSV to >XLS- talss21
- Post #3
- Forum: Visual Basic (Classic)
-
Convert XLS to CSV : Code not working
strFile = replace(strOrigFile,".csv",".xls") Set objExcel = CreateObject("Excel.Application") objExcel.Workbooks.Open strOrigFile objExcel.DisplayAlerts = False objExcel.ActiveWorkbook.SaveAs strFile, -4143 objExcel.DisplayAlerts = False objExcel.ActiveWorkbook.Close objExcel.DisplayAlerts =...- talss21
- Thread
- Replies: 2
- Forum: Visual Basic (Classic)
-
convert XLS file to CSV file using VBS removing the comma separator
Hi I need the xls file to CSV by removing the comma separator and replace it with tilda as my field contains comma into it . Set lstArgs = WScript.Arguments For I = 0 to...- talss21
- Thread
- Replies: 7
- Forum: Visual Basic (Classic)
