|
office 2003 run on office 2007 problems???
I have a file with macro done using excel office 2003. I have tried it on a
computer with office 2007. When I run the file it keeps debugging. Is there a way to make this file compatible with office 2007. -- Bob |
office 2003 run on office 2007 problems???
Post the debug code line Bob
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bob" wrote in message ... I have a file with macro done using excel office 2003. I have tried it on a computer with office 2007. When I run the file it keeps debugging. Is there a way to make this file compatible with office 2007. -- Bob |
office 2003 run on office 2007 problems???
It says something like:
cant recognize Project or Object Library -- Bob "Ron de Bruin" wrote: Post the debug code line Bob -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bob" wrote in message ... I have a file with macro done using excel office 2003. I have tried it on a computer with office 2007. When I run the file it keeps debugging. Is there a way to make this file compatible with office 2007. -- Bob |
office 2003 run on office 2007 problems???
Sorry it should say
Cant find project or object library -- Bob "Bob" wrote: It says something like: cant recognize Project or Object Library -- Bob "Ron de Bruin" wrote: Post the debug code line Bob -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bob" wrote in message ... I have a file with macro done using excel office 2003. I have tried it on a computer with office 2007. When I run the file it keeps debugging. Is there a way to make this file compatible with office 2007. -- Bob |
office 2003 run on office 2007 problems???
In the VB Editor, go to Tools menu References. Are there any items marked
[MISSING]? - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "Bob" wrote in message ... Sorry it should say Cant find project or object library -- Bob "Bob" wrote: It says something like: cant recognize Project or Object Library -- Bob "Ron de Bruin" wrote: Post the debug code line Bob -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bob" wrote in message ... I have a file with macro done using excel office 2003. I have tried it on a computer with office 2007. When I run the file it keeps debugging. Is there a way to make this file compatible with office 2007. -- Bob |
office 2003 run on office 2007 problems???
Hi Jon,
I followed your instructions and there were alot marked as missing. I ticked all of them then tried the file the following message came up: compile error cant find object library. I then checked reference again and found all missing agian. I then checked the object library and tried again and the following message came up: name conflict with project & object library. -- Bob "Jon Peltier" wrote: In the VB Editor, go to Tools menu References. Are there any items marked [MISSING]? - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "Bob" wrote in message ... Sorry it should say Cant find project or object library -- Bob "Bob" wrote: It says something like: cant recognize Project or Object Library -- Bob "Ron de Bruin" wrote: Post the debug code line Bob -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bob" wrote in message ... I have a file with macro done using excel office 2003. I have tried it on a computer with office 2007. When I run the file it keeps debugging. Is there a way to make this file compatible with office 2007. -- Bob |
office 2003 run on office 2007 problems???
What were the missing references? Maybe we can systematically go through the
list. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Bob" wrote in message ... Hi Jon, I followed your instructions and there were alot marked as missing. I ticked all of them then tried the file the following message came up: compile error cant find object library. I then checked reference again and found all missing agian. I then checked the object library and tried again and the following message came up: name conflict with project & object library. -- Bob "Jon Peltier" wrote: In the VB Editor, go to Tools menu References. Are there any items marked [MISSING]? - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "Bob" wrote in message ... Sorry it should say Cant find project or object library -- Bob "Bob" wrote: It says something like: cant recognize Project or Object Library -- Bob "Ron de Bruin" wrote: Post the debug code line Bob -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bob" wrote in message ... I have a file with macro done using excel office 2003. I have tried it on a computer with office 2007. When I run the file it keeps debugging. Is there a way to make this file compatible with office 2007. -- Bob |
office 2003 run on office 2007 problems???
Thanks for getting back to me Jon, I am not with the computer in question at
the moment but I will send you the list later on. -- Bob "Jon Peltier" wrote: What were the missing references? Maybe we can systematically go through the list. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Bob" wrote in message ... Hi Jon, I followed your instructions and there were alot marked as missing. I ticked all of them then tried the file the following message came up: compile error cant find object library. I then checked reference again and found all missing agian. I then checked the object library and tried again and the following message came up: name conflict with project & object library. -- Bob "Jon Peltier" wrote: In the VB Editor, go to Tools menu References. Are there any items marked [MISSING]? - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "Bob" wrote in message ... Sorry it should say Cant find project or object library -- Bob "Bob" wrote: It says something like: cant recognize Project or Object Library -- Bob "Ron de Bruin" wrote: Post the debug code line Bob -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bob" wrote in message ... I have a file with macro done using excel office 2003. I have tried it on a computer with office 2007. When I run the file it keeps debugging. Is there a way to make this file compatible with office 2007. -- Bob |
office 2003 run on office 2007 problems???
I managed to sort the problem by coping the items ticked in the reference box
from the tool menu and it works now. -- Bob "Bob" wrote: Thanks for getting back to me Jon, I am not with the computer in question at the moment but I will send you the list later on. -- Bob "Jon Peltier" wrote: What were the missing references? Maybe we can systematically go through the list. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Bob" wrote in message ... Hi Jon, I followed your instructions and there were alot marked as missing. I ticked all of them then tried the file the following message came up: compile error cant find object library. I then checked reference again and found all missing agian. I then checked the object library and tried again and the following message came up: name conflict with project & object library. -- Bob "Jon Peltier" wrote: In the VB Editor, go to Tools menu References. Are there any items marked [MISSING]? - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "Bob" wrote in message ... Sorry it should say Cant find project or object library -- Bob "Bob" wrote: It says something like: cant recognize Project or Object Library -- Bob "Ron de Bruin" wrote: Post the debug code line Bob -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bob" wrote in message ... I have a file with macro done using excel office 2003. I have tried it on a computer with office 2007. When I run the file it keeps debugging. Is there a way to make this file compatible with office 2007. -- Bob |
| All times are GMT +1. The time now is 08:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com