mcdhappy80
Registered User.
- Local time
- Today, 22:18
- Joined
- Jun 22, 2009
- Messages
- 347
Here's what I've noticed and what is now causing me a problem.
Depending on the Regional and Language Options settings in MS Windows control panel, the date I import in VBA code has different formats.
When I'm on my native regioanal settings the date should be displayed in one of these two formats (for June the 2nd, 2000 for example):
01. June. 2000; 01. 06. 2006
Most of the time (on other users machines) the date is displayed in "English" format (for example):
June, the 1st, 2000; 06/01/2000.
Can I somehow make sure (through VBA code) that no matter in what format the date is set on users machine, when I import it in VBA to manipulate with it, I can display it to VBA in the format I need (my native format)?
Thank You.
Depending on the Regional and Language Options settings in MS Windows control panel, the date I import in VBA code has different formats.
When I'm on my native regioanal settings the date should be displayed in one of these two formats (for June the 2nd, 2000 for example):
01. June. 2000; 01. 06. 2006
Most of the time (on other users machines) the date is displayed in "English" format (for example):
June, the 1st, 2000; 06/01/2000.
Can I somehow make sure (through VBA code) that no matter in what format the date is set on users machine, when I import it in VBA to manipulate with it, I can display it to VBA in the format I need (my native format)?
Thank You.
