Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros don't work on another PC
HI there,
what are the errors you mentioned? ManualMan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros do not work anymore! | Excel Discussion (Misc queries) | |||
PC macros won't work on MAC | Excel Discussion (Misc queries) | |||
how do i use macros to work out commissions | Excel Worksheet Functions | |||
macros dont work | Excel Programming | |||
Macros work on my computer but not another??? | Excel Programming |