Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Editing an Office 2003 Document using Office 2007 | Excel Worksheet Functions | |||
Office 2007 compatibility pack on Office 2003 (slow network file | Setting up and Configuration of Excel | |||
Office 2007 compatibility at office 2003 is not working for graphs | Excel Discussion (Misc queries) | |||
Opening an Office 2007 Excel file in Office 2003 | Excel Discussion (Misc queries) | |||
Performance not upto Office 2003 standards in Office 2007 | Excel Discussion (Misc queries) |