BIGAL Posted March 11, 2010 Posted March 11, 2010 Hi guys & Gals We have a bit of a wierd situation we have 1 pc that when we go to run a VBA program it opens the VBA manager and jumps to a point in the code. We have 8 pc's in total all others work fine. Any ideas would be helpfull. Quote
MSasu Posted March 11, 2010 Posted March 11, 2010 Not sure about your environment, but check the Local Settings in Control Panel on that particular station – you may learn that it use "," as decimal separator instead of "." and this will raise an error when a numerical string is passed to CDbl function. Regards, Quote
BIGAL Posted March 15, 2010 Author Posted March 15, 2010 Thanks for your suggestion but where do you find this Local settings to change can not seem to find anything in control panel that changes the , to a . Quote
MSasu Posted March 15, 2010 Posted March 15, 2010 Please use the route below to locate the symbol that is used as decimal separator on a workstation: Control Panel --> Regional and Language Options --> Regional Options --> Customize... --> Numbers --> Decimal symbol Regards, Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.