C
Christian
Hi all,
Background
I have a vba rutine that imports a csv file to excel.
The source application where the data is taken from sometimes contain a
semicolon sign ";" with a text field. The semicolon will cause an offset
of the data in excel when the user regional settings is using semicolon
as a delimiter.
Question
is it possible to use some vba code that will replace ";" with for
example "|" before the import of the file to excel is done?
Any ideas are warmly welcome
- Chr
Background
I have a vba rutine that imports a csv file to excel.
The source application where the data is taken from sometimes contain a
semicolon sign ";" with a text field. The semicolon will cause an offset
of the data in excel when the user regional settings is using semicolon
as a delimiter.
Question
is it possible to use some vba code that will replace ";" with for
example "|" before the import of the file to excel is done?
Any ideas are warmly welcome
- Chr