Saving excel file as .csv via OLE program

Former Member — Wed, 01 Apr 2009 08:31:01 GMT

Hi all,

in my abap OLE program i'd like to save an excel file as .csv file with ";" separator according to the frontend settings. Unfortunately the file is saved with "," separator (and not ";").

Here is the code:

<<...

call method of e_newappl 'SAVEAS'

exporting

#1 = path

#2 = '23' ....>>

I also tried 6, 22, 24 as #2 parameter values, with the same result. Running the program in differents workstations (all with ";" separator in the general settings) sometimes i get a file with ";" and sometimes with ",".

Is there a way to always get the .csv file with ";"? Or at least to check what separator will be used?

Thanks for replies.

Re: Saving excel file as .csv via OLE program

Former Member — Wed, 01 Apr 2009 08:34:04 GMT

hi,

please check this similar thread for the answer

thanks

topic Re: Saving excel file as .csv via OLE program in Application Development and Automation Discussions

Saving excel file as .csv via OLE program

Re: Saving excel file as .csv via OLE program