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
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