![]() |
Just upgraded to Vista Macros unstable
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 |
Just upgraded to Vista Macros unstable
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. -- Regards, Tom Ogilvy "Snowfire" wrote: 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 |
All times are GMT +1. The time now is 04:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com