excel macro in '97 does not work in Vista

[basilio]

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

 

[Bob Phillips]

In the VBIDE, go to Tools>References, 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)

 

[Jon Peltier]

Variables not already declared must be declared,

shortcut cell reference is not understood

FWIW, these are not good programming practices. You should always require
variable declaration, and you should avoid shortcut references and instead
reference objects fully.

- Jon