Just upgraded to Vista Macros unstable

[Snowfire]

When trying to run my well established macro driven applications on a
new vista computer I get problems with functions like Right, SendKeys
(to name just two) needing the prefix Application.
ie. Application.Right( etc. or Application.Sendkeys etc. prefixed
to stop them crashing the macro. After a torturous path to get Vista
up and running all my programs this is all I DON'T need.....

Any help to fix this, short of rewriting too many to count Excel
programs, would be very much appreciated.

Mike

 

[Guest]

once you get the error, look in Tools=>References in the VBE (you may have to
hit RESET first). You should see one or more references marked as MISSING.
Correct these.