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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Microsoft Excel VBA Code to convert .xls file to .csv file
- Thread starter tekvb1977
- Start date
Hi there,
You can still use the same save feature, just change the syntax slightly...
ActiveWorkbook.SaveAs "C:\YourPathGoesHere\YourFileNameGoesHere.csv", FileFormat:=xlCSV
change out ActiveWorkbook for whatever workbook you're wanting to save.
HTH
-----------
Regards,
Zack Barresse
You can still use the same save feature, just change the syntax slightly...
ActiveWorkbook.SaveAs "C:\YourPathGoesHere\YourFileNameGoesHere.csv", FileFormat:=xlCSV
change out ActiveWorkbook for whatever workbook you're wanting to save.
HTH
-----------
Regards,
Zack Barresse
- Status
Similar threads
- Question