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