G
Guest
My company has recently upgraded us from Windows2000/Excel2000 to
WindowsXP/Excel2003.
I am having a problem converting .xls to .csv that uses ";" semicolon as the
separator.
The Regional Setting for List Separator is ";" semicolon.
My old code is this:
Awb.SaveAs Filename:=Left(Awb.Name, Len(Awb.Name) - 4), FileFormat:=xlCSV
This issue seems to be specific to the code I am using - I have tried to
manually save an xls file to csv and it worked fine.
Is there a way to fix my code so that the .csv uses ";" as the separator ?
Thank you in advance.
WindowsXP/Excel2003.
I am having a problem converting .xls to .csv that uses ";" semicolon as the
separator.
The Regional Setting for List Separator is ";" semicolon.
My old code is this:
Awb.SaveAs Filename:=Left(Awb.Name, Len(Awb.Name) - 4), FileFormat:=xlCSV
This issue seems to be specific to the code I am using - I have tried to
manually save an xls file to csv and it worked fine.
Is there a way to fix my code so that the .csv uses ";" as the separator ?
Thank you in advance.