Malfunction of Excel macro on some computers. 1

[Eshman]

I have a macro with passwords on some functions. In my password routine I use the UCase function to compare the user input to the 'invalid' password to see if I should notify the user that the password is invalid or that the password is case sensitive. On some of our computers the macro cannot find the UCase function.

Also I use the Format function to format numbers with leading zeros with the same result (cannot find the Format function).

We are running Office 2000 on Windows XP Professional. I have service pack 3 and it works on my computer but our network administrator also has service pack 3 and it bombs on his computer. We also tried detect and repair on one computer that can't run the macro and it did not help.

Does anyone have any idea what could be causing this problem? I'm tearing my hair out and I don't have much to tear out!

 

[TonyJollans]

Hi Eshman,

The most likely cause is a missing reference, causing the VBA function library to not be found.

In the VBE, go to Tools > References and see if any are flagged as MISSING. Either uncheck the box beside them or resolve them and see if that helps.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.

 

[Eshman]

Thank you Tony.

That did the trick. It was the comdlg32.ocx file that was missing. Actually it wasn't missing, it was just that the machines where the macro didn't work had an older version of the comdlg32.ocx file. I still don't know why it caused those functions to be unavailable unless there is something in the older version of the comdlg32.ocx file that interferes with the functions. Anyway, I replaced the older version and it all works.

Thanks again,

Paul Eshman