VBA Excel2003<>Excel2007

G

G.P.N.L. c.v.a.

I am not very well in VBA.
UDF worked normally in Excel2003.
Taken over to a new computer (export-copy-import) with Excel2007, and when
trying to us it (F9), the VBE is loaded, the "function-declaration becomes
yellow, and I get "Compile error. Can't find poject or library".
What is happening ?
Where is Excel2007 different from Excel2003 ?
 
S

Stefan B Rusynko

If your project referenced specific 2003 libraries then you need to edit the project to remove the 2003 libraries, and add the
equivalent 2007 library




I am not very well in VBA.
UDF worked normally in Excel2003.
Taken over to a new computer (export-copy-import) with Excel2007, and when
trying to us it (F9), the VBE is loaded, the "function-declaration becomes
yellow, and I get "Compile error. Can't find poject or library".
What is happening ?
Where is Excel2007 different from Excel2003 ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA errors in 2007 (works fine in 2003) 14
Excel2000 worksheet Change event doesn't work in Excel2003 or higher 3
Reference Outlook in Excel2003, but not working in Excel2000. 0
How do I ref OutlookCOM in my Excel2003 PC and run it on Excel2000 0
VBA function changing name 1
Object libray invalid problem 0
C-DLL-VBA-EXCEL strings 0
C-DLL-VBA to excel (strings) 0

Top