View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default 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