Dear Experts.
When I run my excel file on some other computer, it displays following error message
Can’t find Project or Library
Then cursor stops on word Format
Date1=Format(now,”dd-mm-yy”)
On my personal computer the Regional setting is “dd-mm-yy”
May Date setting is different on other computer.
My question are:
1- How to overcome this problem?
2- How to automatically change Control Panel’s Regional and Language Options through Excel codes?
I wan to add some module to change Date setting to “dd-mm-yy” on every computer onwhich the excel file will execute.
Thanks
Bookmarks