PDA

View Full Version : Load Word object library



Asi
02-19-2009, 12:50 AM
Hi

I am writing an Excel macro that opens a word doc and update it's links.
on my dev machine I managed to do this but I manually added the Word object library via Tools -> references -> checking the relavant "Microsoft Word object library".

The question is: When I send this excel file (with the macro) to a different machine and try to run the macro, I get a message "Can't find project or Library". In order to resolve it - I filled the check box on the References on this machine as well.

Is there a way to Autommatically /dynamically load the library via the vba code just before the part where I have to open the word doc ?



Thanks
Asi

lucas
02-19-2009, 01:56 AM
Research Early and Late binding:

http://www.excelguru.ca/node/13

Asi
02-19-2009, 08:43 AM
Thanks A lot ...