Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a changing cell reference as part of a workbook name 2 link | Excel Discussion (Misc queries) | |||
Refresh pivot table in workbook A when changing a cell in workbook | Excel Worksheet Functions | |||
Prevent List Box Reference from Changing when workbook closes? | Excel Discussion (Misc queries) | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
Changing Reference Dynamically | Excel Programming |