Refreshing DecimalSeparator in Excel 2000

A

Adax

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
 
A

Adax

U¿ytkownik "Adax said:
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
Click to expand...

Who help me, please ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help on Excel 2000 1
Weird screen refresh problem in Excel 2003 - bits of differentworksheets display. 5
date in excel 16
Userform as childwindow in statusbar not redrawn when Excel window isresized 10
XML API in VBA under Excel? 1
Query fails, requiring excel to be closed and restarted 1
Excel file types? 3
break into an invisible instance of Excel 2

Top