Changing the workbook reference
 

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

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

Changing the workbook reference
 

Hi Bob
Thank you for your reply.
It is better for me to have only one central copy of the add-in as I
often have to 'tweak' the code. Having multiple copies would make
'tweaking' very difficult. Any other possibilities ?

Thank you for your reply

Andrew Bourke

Bob Phillips wrote:
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 )

Changing the workbook reference
 

HI Andrew,

If you store the add-in on a server, it would get picked up by everyone when
Excel starts. This way you can keep updating it.

--
HTH

Bob Phillips

"Andrew B" wrote in message
...
Hi Bob
Thank you for your reply.
It is better for me to have only one central copy of the add-in as I
often have to 'tweak' the code. Having multiple copies would make
'tweaking' very difficult. Any other possibilities ?

Thank you for your reply

Andrew Bourke

Bob Phillips wrote:
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 )