Object Library

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GoTTi - 12 Sep 2006 11:00 GMT

I have written a macro in Excel 2002/XP which uses different MS Object
Libraries (Excel, Office & PowerPoint) and it works fine.
When I save the file in Excel 2003 the references get changed automatically
to version 11 and the file works but when I open the file in Excel 2002
again the Object Library for PowerPoint stays on version 11 all others
swiches back to version 10. This produces errors (Missing Object Library).

Does anyone have a clue why this Object Library doesn't swich back?

Thanks in advance
GoTTi

Reply to this Message

Jim Thomlinson - 12 Sep 2006 17:13 GMT

You are better off to use late binding. (Bind to the library at run time, not
at design time). Remove the references and use code similar to this

Dim appExcel As Object
Dim appWord As Object

Set appExcel = CreateObject("Excel.Application")
Set appWord = CreateObject("Word.Application")

appExcel.Quit
appWord.Quit
Set appExcel = Nothing
Set appWord = Nothing

Signature

HTH...

Jim Thomlinson

> I have written a macro in Excel 2002/XP which uses different MS Object
> Libraries (Excel, Office & PowerPoint) and it works fine.
[quoted text clipped - 7 lines]
> Thanks in advance
> GoTTi

Reply to this Message

GoTTi - 13 Sep 2006 07:19 GMT

Thank you, Jim!

I think this did the trick!

Regards,
GoTTi

> You are better off to use late binding. (Bind to the library at run time,
> not
[quoted text clipped - 24 lines]
>> Thanks in advance
>> GoTTi

Reply to this Message

Rate this thread: