Compatibillity issues 2003 v 2007

**twinpowr** · 02-23-2011, 05:05 AM

Hi guys,

I am having problems with two vba lines that work okay at home where i am using 2007. but when i try and run the code in 2003 which i use at work i get a "Can't find project or library"

The lines i am having difficulty with are

Please Login or Register  to view this content.

and this line

Please Login or Register  to view this content.

Which library do i need to install, and can i do this programatically at workbook open

Any help would be greatly appreceiated.

Ally.

**DonkeyOte** · 02-23-2011, 05:09 AM

In VBE go to Tools -> References and check which library is listed as missing - post back.

I suspect you've early binded to something - eg Outlook 12.0 etc... if so you need to select the 11.0 equivalent in your 2003 file.

**twinpowr** · 02-23-2011, 05:24 AM

Hi

thanks for your reply.

i am using ms office 11.0 object library in excel 2003. not sure how to select the equivilant library. or do i need to choose different commands. within my vba code.

Still new to vba so quite confused at the moment.

Thanks for any help

Ally.

**DonkeyOte** · 02-23-2011, 05:34 AM

Please check References within VBE and report back with whatever is listed as MISSING

**twinpowr** · 02-23-2011, 05:45 AM

Hi,

This is showing as missing in the vbe references

Missing: HTML.XLAM
missing: lookup.xlam
missing: sumif.xlam
missing:atpvbaen.xlam
missing:eurotool.xlam
missing:solver.xlam

thanks for your help, i hope this is what you are looking for

Ally,.

**DonkeyOte** · 02-23-2011, 05:48 AM

The above are all 2007 Add-Ins ... if you're not using them in your file remove the references.

**twinpowr** · 02-23-2011, 06:00 AM

Thanks DonkeyOte.

Its easy when you know how.

Feel a little stupid actually, should probably have tried that first

Thank you very much for your help. All up and running now.

Just one more question, will i need to unload these every time the worksheet loads, or can i unload them at workbook open.

Thanks again

Ally.

**DonkeyOte** · 02-23-2011, 06:08 AM

If you save with the add-ins disabled then no I wouldn't think so (of course we're assuming you don't need the 2003 equivalent add-ins)

**twinpowr** · 02-23-2011, 06:12 AM

Hi,

So far i dont, but will check back, if i run into any other problems

Thanks once again for your help

Ally.

Compatibillity issues 2003 v 2007

LinkBack

Thread Tools

Rate This Thread

Display

Compatibillity issues 2003 v 2007

Re: Compatibillity issues 2003 v 2007

Re: Compatibillity issues 2003 v 2007

Re: Compatibillity issues 2003 v 2007

Re: Compatibillity issues 2003 v 2007

Re: Compatibillity issues 2003 v 2007

Re: Compatibillity issues 2003 v 2007

Re: Compatibillity issues 2003 v 2007

Re: Compatibillity issues 2003 v 2007

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions