View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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