Windows Short date format etc. thru VBA

[arvindn]

I want to access and change the following things thru VBA (including the use of Windows API if needed) :-

1) The default short date format in Windows that is usually accessed thru
Control Panel -> Regional Settings -> Date

2) The no. of digits in group accessed thru
Control Panel -> Regional Settings -> Number

3) The menu/toolbar fontname , fontsize and fontweight properties usually accessed thru
Control Panel -> Display -> Appearance

Finally, I want to know of a way to create a shortcut to my file and place it on desktop thru VBA.

Any help is greatly appreciated.
Thanks in advance.

 

[Mile-O]

For 1: e.g. changing the system date (to 1st day of year)

Date$ = DateSerial(2003, 1, 1)

Same goes with Time$ for times.

 

[arvindn]

Thanks a lot. The knowledge imparted by u is also useful and i have noted it. But...

I want to change the default short date format of Windows from m/d/yy to dd/mm/yy thru VBA code

 

[Mile-O]

I want to change the default short date format of Windows from m/d/yy to dd/mm/yy thru VBA code

Click here

 

[arvindn]

Thanks once again.Have seen the site and downloaded the web page. Will let u know the results.