Changing the workbook reference
Andrew,
If you load add-in on each machine, you can refer directly to the add-in
procedures
application.run ("myAddin.cla!myProc","val1",a_number )
--
HTH
Bob Phillips
"Andrew B" wrote in message
...
Hi
I have a number of workbooks on a network that refer to a common
workbook (add-in) ABModule05.xla.
If a workbook was used on a laptop and then copied back onto a network
computer then the workbook doesn't know where to look for the reference
workbook ABModule.xla. The message "Can't find project or library"
appears.
Is it possible to set the reference in VBA coding? Can each workbook
check to see what system it is on then refer to the appropriate
reference add-in ?
Thanks in anticipation
Andrew B
|