Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refreshing DecimalSeparator in Excel 2000
Hello, I have problem at Win2k computer with Excel2000.
I want change by VBA and API DecimalSeparator: sometimes I need "," or "." In Excel 2003 I make it internally by help new excel function: Application.DecimalSeparator = "." Unfortunately, in Excel 2000 it is possible ony by API and SetLocaleInfo and it works but with refresh excel problem. When I make it manually, Excel immediatelly changes DecimalSeparator. When I make it programming I have to reopen excel again..... Is it possible make it without reopen excel? Greetings |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refreshing DecimalSeparator in Excel 2000
Użytkownik "Adax" napisał w wiadomo¶ci
... Hello, I have problem at Win2k computer with Excel2000. I want change by VBA and API DecimalSeparator: sometimes I need "," or "." In Excel 2003 I make it internally by help new excel function: Application.DecimalSeparator = "." Unfortunately, in Excel 2000 it is possible ony by API and SetLocaleInfo and it works but with refresh excel problem. When I make it manually, Excel immediatelly changes DecimalSeparator. When I make it programming I have to reopen excel again..... Is it possible make it without reopen excel? Greetings Who help me, please ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application.DecimalSeparator | Excel Programming | |||
I cannot edit cell format in Excel 2000 (Part of office 2000)! | Excel Discussion (Misc queries) | |||
Create macro to download access 2000 table to excel 2000 spreadsheet | Excel Programming | |||
Code-signing certificate problems in Excel 2000 with Windows 2000 | Excel Programming | |||
Application.DecimalSeparator usage. | Excel Programming |