ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macros don't work on another PC (https://www.excelbanter.com/excel-programming/315692-macros-dont-work-another-pc.html)

Larry Graff[_2_]

Macros don't work on another PC
 
I have developed some macros that I have been using for several years.
Recently I moved the macors over to another users PC. When executing the
macors, I usually get various errors in the VB Editor. Both PC's are running
XP and Office 2003.

Thought it might have to do with References or libraries, but both PC seem
to be the same.

How do I get the macros to run on the other PC? Need Help...

Thanks in Advance

ManualMan

Macros don't work on another PC
 
HI there,

what are the errors you mentioned?

ManualMan


Larry Graff[_3_]

Macros don't work on another PC
 
Manual Man,

I have had the user execute the macro, the error is 'Can't find project or
library.' It seems to fail on the executable line in the macro. I have tried
this same macro on a test PC and updated some of the libraries. The macro
got further but died on a Set statement. I'm at a loss. Hope you have some
ideas.

"ManualMan" wrote:

HI there,

what are the errors you mentioned?

ManualMan



Myrna Larson

Macros don't work on another PC
 
In the VB editor on the problem machine, go to Tools/References. I'm sure
you'll find some that are marked as "missing". You have to uncheck these if
they aren't needed, or find them on this machine.

On Wed, 3 Nov 2004 13:19:07 -0800, "Larry Graff"
wrote:

Manual Man,

I have had the user execute the macro, the error is 'Can't find project or
library.' It seems to fail on the executable line in the macro. I have tried
this same macro on a test PC and updated some of the libraries. The macro
got further but died on a Set statement. I'm at a loss. Hope you have some
ideas.

"ManualMan" wrote:

HI there,

what are the errors you mentioned?

ManualMan





All times are GMT +1. The time now is 09:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com