Office 12.0/14.0 Library

Aurum

New Member
Joined
Mar 31, 2010
Messages
9
Hi,

In my VBA macro I added called "Microsoft Outlook 12.0 Library" to reference under MS Excel 2007 SP2 (12.0) environment. When my colleague opened the same file under MS Excel 2010 (14.0) , the reference got "upgraded" automatically to 14.0. OK that's fine. But after he saved the file I needed to reopen it again, it showed "Error in Loading DLL" and "MISSING:Microsoft Outlook 14.0 Library" in reference. I tried removing the 14.0 Library and adding back 12.0, but I couldnt as the error persisted. Any suggestion how I could handle this problem? Thanks.
 

Colin Legg

MrExcel MVP, Like totally RAD man
Joined
Feb 28, 2008
Messages
3,497
Hi,

When users on different versions of office are sharing a communal file, the usual workaround is to use late binding so that a library reference is not required.
 

Aurum

New Member
Joined
Mar 31, 2010
Messages
9
Thanks. I think I can solve this problem after I look for "late binding".
 

Forum statistics

Threads
1,085,307
Messages
5,382,846
Members
401,807
Latest member
xlWatcher

Some videos you may like

This Week's Hot Topics

Top