Office 12.0/14.0 Library

[Aurum]

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]

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]

Thanks. I think I can solve this problem after I look for "late binding".