Hi
I am searching for a solution to this little problem:
when saving a spreadsheet in csv-format from the user interface of Excel (a Danish version), the file is saved with a ";" as divider (Danish), which is what I want, but when the saving is executed in code like the code below, the file is saved with a "," as divider (USEnglish). When the file then is opened in Excel, each row of data are placed in one cell instead of multiple cells.
ActiveWorkbook.Worksheets(2).SaveAs Filename:= _
"etrade.csv", _
FileFormat:=xlCSV, CreateBackup:=False, local:=True
Please help me as I have a deadline in two days
trolle
Bookmarks