Export to text file by use " ; " as separator

[Eva]

Dear Sir,

I need to export data as text file to users but they need
to use semi-colon " ;" to separate each column. I check
the file type which hasn't got this type. How can I solve
it ?

Thanks.
Eva

 

[Harlan Grove]

I need to export data as text file to users but they need
to use semi-colon " ;" to separate each column. I check
the file type which hasn't got this type. How can I solve
it ?

The simplest way to create CSV-like files using ; rather than , as field
separators would be to run Regional Settings in Windows's Control Panel, click
on the Number tab, change the list separator to ;, switch to Excel, save as CSV
file, switch back to Control Panel/Regional Settings, change the list separator
back to , and exit from Control Panel. There are also ways to do this using
macros.

 

[Eva]

Dear Sir,

How can I do this in macros as user may not want to change
to ;?

Thanks
Eva

 

[Eva]

Dear Sir,

How can I use macro to set ; instead of changing regional
setting?

Thanks
Eva

 

[Harlan Grove]

How can I use macro to set ; instead of changing regional
setting?

....

Follow the link in the following

http://groups.google.com/[email protected]