office 2003 run on office 2007 problems???

[Bob]

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.

 

[Ron de Bruin]

Post the debug code line Bob

 

[Bob]

It says something like:
cant recognize Project or Object Library

 

[Bob]

Sorry it should say
Cant find project or object library
--
Bob

It says something like:
cant recognize Project or Object Library

 

[Jon Peltier]

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-06-ACNJ/AdvExcelConf200906ACNJ.html
_______

 

[Bob]

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

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-06-ACNJ/AdvExcelConf200906ACNJ.html
_______

 

[Jon Peltier]

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/
_______

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

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-06-ACNJ/AdvExcelConf200906ACNJ.html
_______

Sorry it should say
Cant find project or object library
--
Bob


:

It says something like:
cant recognize Project or Object Library
--
Bob


:

Post the debug code line Bob


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




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]

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

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/
_______

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

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-06-ACNJ/AdvExcelConf200906ACNJ.html
_______


Sorry it should say
Cant find project or object library
--
Bob


:

It says something like:
cant recognize Project or Object Library
--
Bob


:

Post the debug code line Bob


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




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]

I managed to sort the problem by coping the items ticked in the reference box
from the tool menu and it works now.
--
Bob

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

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/
_______

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


:

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-06-ACNJ/AdvExcelConf200906ACNJ.html
_______


Sorry it should say
Cant find project or object library
--
Bob


:

It says something like:
cant recognize Project or Object Library
--
Bob


:

Post the debug code line Bob


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




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.