Activating References

[zandsc1]

I have a database that I use to keep track of quotations at our workplace. When a new quote is created the database makes a copy of a standard word template and replaces certain strings wtih information unique to the quote (quote number, revision, etc.) The user can also create an excel document if they wish. In order to do these functions, I had to load the microsoft word x.0 object library and microsoft excel x.o object library.

I created the database in my version of access, which is 2007, meaning by default I load in word 12.0 object library and execl 12.0 object library, however other users have old versions of word/excel so they need to load in the 11.0 libraries. I tried to add a routine to the database that checked for the 12.0 object library and loaded in the 11.0 object library if it was not found, but when I used references.addfromfile(filename) I got errors claiming the library was already loaded.

Long story short: the users with the old version have the 11.0 libraries available, but not activated. Is there a command or way to activate those already loaded libraries?

Thanks

 

[HughLerwill]

You can maintain your refs into the libraries for use of Constants like xlNormal, but use Late Binding as in eg;

Dim xlobj
set xlobj = CreateObject("Excel.Application")
'note: this will work without any ref into an Excel library, a reference into the library can still be an advantage though because you can then use Constants like xlNormal in your code.

in place of Early Binding as in;

Dim xlObj as New Excel.Application 'and its variations
'note: you must have a ref into an Excel library to use this and it is library version dependant.

Early binding has theoretical speed advantage but it is library version dependant, Late binding is not.

 

[HughLerwill]

My bad; that should have been;

Dim xlobj as Object
set xlobj = CreateObject("Excel.Application")
'note etc

 

[zandsc1]

Thanks Hugh, I'd heard about late binding before but wasn't totally sure how it worked. I'll give this a try.