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
and this lineIf Trim(FindString) <> "" Then
Which library do i need to install, and can i do this programatically at workbook openData(Dn, Ac) = Format(Data(Dn, Ac), "dd/mm/yy")
Any help would be greatly appreceiated.
Ally.
Last edited by romperstomper; 02-23-2011 at 08:52 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.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
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.
Please check References within VBE and report back with whatever is listed as MISSING
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
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,.
The above are all 2007 Add-Ins ... if you're not using them in your file remove the references.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
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.
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)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Hi,
So far i dont, but will check back, if i run into any other problems
Thanks once again for your help
Ally.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks