Ihave automated the following:
Open an existing excel spreadsheet, refresh the data, save as .csv and send to another location. My problem is the .csv file is being save with a tab format instead of comma. How do I tell MS that I want the delimiter to be a comma?
csv file saves as tab delimited
Moderators: Dorian (MJT support), JRL
Hi nixonj,
First make sure Windows is not defining csv files to have a tab delimiter.
http://office.microsoft.com/en-us/excel ... 51033.aspx
Read the section "Change the separator in all .csv text files".
If that is not the problem, please provide the parts of your script that open excel, open the xls, and save the csv file. Then the solution can use a method compatible with the rest of your script.
Gale
First make sure Windows is not defining csv files to have a tab delimiter.
http://office.microsoft.com/en-us/excel ... 51033.aspx
Read the section "Change the separator in all .csv text files".
If that is not the problem, please provide the parts of your script that open excel, open the xls, and save the csv file. Then the solution can use a method compatible with the rest of your script.
Gale
