Change to SP3 affecting my macros

[John Robert]

I have had some macros working on computers in my company since 1998
and they have worked fine until now. Some of my users have been
upgraded to OS Windows 2000 SP3. After the upgrade, the macros do not
work. It gets hung up on the simplest of string functions. The error
message reads "Library not available" or something like that.

Does anyone know what could be happening? Is the registry being
altered in some way: I would appreciate any help that you could give
me.

John Robert
(e-mail address removed)

 

[Steve Lang]

Hi John,

Check the references in your project (In the VBE, go to Tools | References).
It sounds like a dll or two got blown away in the SP upgrade. The ones that
are causing the problem will be prefaced with "MISSING" in the list of
references.

HTH and have a great day!
Steve

 

[John Robert]

Thanks for your response Steve. Where will this missing message show
up? In the references dialog box (right next to where you would check
the library)?

Also, if the DLL is missing, where would I get a new one?

Thanks in advance for your help!!

John Robert

 

[Steve Lang]

Hi John,

If a referenced dll is no longer available to the macro that fact will be
apparent when you open the References Dialog box.
As for where you would get a replacement dll, depending what it was, if it
was a publicly available dll, you could probably google it and get a copy
somewhere. If it was privately developed, you would have to contact the
developer.

HTH and have a great day!

Steve Lang