excel macro in '97 does not work in Vista
In the VBIDE, go to ToolsReferences, and see if any items have MISSING
alongside them. If so, uncheck these items.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"basilio" wrote in message
...
I have a lot of Excel '97 files made up in windows 98, containing a lot of
macros.
These macros worked perfectly when I swithed to Windows XP and Excel 2003.
Unfortunately, on Windows Vista all files load normally but their macros
do
not work. Variables not already declared must be declared, shortcut cell
reference is not understood, bit these problems may be resolved. The
"Chr(10)" in messages is not understood and I cannot find a solution on
the
error message "compile error in hidden module ..XX. The compilation
error
on "chr(10)" is .. 'can't find project or library'.
Any idea to resolve this before going thru to all messages change ??
thank you
--
Basilio
|