excel macro in '97 does not work in Vista
 

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

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

excel macro in '97 does not work in Vista
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"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