Thread: Decimal Symbol
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] somemail@hotmail.com is offline
external usenet poster
 
Posts: 1
Default Decimal Symbol

Is there a way, to change the "Decimal Symbol" character
in Control panel/Regional Settings, using VBA.
I need to do this because I have workbooks that are going
to be seen in Europe, USA, and LatinAmerica, and I am
generating PDF files for them, so I don't have chance to
send them Excel Files and I need to convert the Excel File
previously to the PDF generation,
I wish I could change the "Decimal Separator" and
the "Digit Grouping Symbol" directly from VBA to generate
the PDF file, and then return it to my own settings in my
computer.

If you are going to suggest me that I use Format, I prefer
to seek for some System DLL library to chagnge the
settings because there are a tons of Graphics, sheets and
Equations.
Thanks in advance
Francisco Mariscal

fcomariscal at hotmail dot com