View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Application.DecimalSeparator usage.

The 3 is the value of the constant - it has no relationship to which
separator is being used.

--
Regards,
Tom Ogilvy


"Beto" wrote in message
...
BrianB < wrote:

I think this is the correct usage :-

x=Excel.XlApplicationInternational.xlDecimalSepara tor


Why is that?
From the inmediate window:

? Application.International(xlDecimalSeparator)
.
? Excel.XlApplicationInternational.xlDecimalSeparato r
3

Wouldn't a "." be easier to use (and read the code) than a 3?

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.