Library Reference issues.  
Author Message
magicalclick





PostPosted: Visual Basic for Applications (VBA), Library Reference issues. Top

Hello guys,

I am building my Excel macros using Excel11.0 library. I only use the syntax that works on Excel 2000, so that my code runs on Excel 2000. So far, my code is created in Excel 2003 editor and runs on both Excel 2003 and Excel 2000.

But if I am referencing another office library like Outlook 11.0 Object in my excel macro, Excel 2000 can't pick up the library. I am creating my macro using Office2003, but there are some computers in my company uses Office2000. And you know upgrading their office is out of my reach. What should I do

Thank you.



Microsoft ISV Community Center Forums3  
 
 
Cindy Meister





PostPosted: Visual Basic for Applications (VBA), Library Reference issues. Top

Go to one of the Office 2000 machines and open your project in the VB
editor on that machine. Reset the Reference on this machine to the
Outlook 2000 version. Do a Debug/Compile to make sure all the code is
correctly recognized. The save while in the VB Editor.

You project should run fine now on all machines, although anything like
this in connection with Office 2000 can be "tricky". You may need to
maintain two copies of your project: one compiled for Office 2000 and
the other for Office 2003.

Good luck :-)

-- Cindy (Word MVP)



 
 
magicalclick





PostPosted: Visual Basic for Applications (VBA), Library Reference issues. Top

Thanks for the reply.

So, I have to have two copies. T___T sob.