ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Just upgraded to Vista Macros unstable (https://www.excelbanter.com/excel-programming/396494-just-upgraded-vista-macros-unstable.html)

Snowfire

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


Tom Ogilvy

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