Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How does Excel Know Where a Referenced Add-In Wbk is Located
I have two workbooks. One workbook is an Add-In Workbook named "QG Add-In"
which contains all my code to manipulate data in the other workbork name "Quote Generator", which by the way is a Read Only workbook. In the VBE, under the Quote Generator I set a reference to the QG Add-In so I can access all the code in it. My question is this. When someone saves their copy of the Quote Generator to a different folder on the server, how does Excel know where to look for the Referenced "QG Add-In.xla" workbook? Sometimes when a sales person opens their copy of the Quote Generator it takes about 1 minute to open the Add-In, why? Is it because it is searching the network? Can I speed it up in some way? Thanks in Advance, -- Cheers, Ryan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How does Excel Know Where a Referenced Add-In Wbk is Located
Ryan,
Ideally, your QG Add-In.xla would essentially contain the workbook Quote Generator - template sheets that it can copy into a new workbook, code, etc. and there should be no need for references or separate workbooks. If you want a separate workbook, require that both the xla and the template be stored in the same folder, and use code in the xla to create a commandbar or ribbon button that the user can use to open the template. HTH, Bernie MS Excel MVP "Ryan H" wrote in message ... I have two workbooks. One workbook is an Add-In Workbook named "QG Add-In" which contains all my code to manipulate data in the other workbork name "Quote Generator", which by the way is a Read Only workbook. In the VBE, under the Quote Generator I set a reference to the QG Add-In so I can access all the code in it. My question is this. When someone saves their copy of the Quote Generator to a different folder on the server, how does Excel know where to look for the Referenced "QG Add-In.xla" workbook? Sometimes when a sales person opens their copy of the Quote Generator it takes about 1 minute to open the Add-In, why? Is it because it is searching the network? Can I speed it up in some way? Thanks in Advance, -- Cheers, Ryan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to open a file in excel located on another computer | Excel Discussion (Misc queries) | |||
Open PDF located in excel with macro | Excel Programming | |||
Is there a grading template located in Excel? | Excel Discussion (Misc queries) | |||
does excel know in which cell a button is located? | Excel Programming | |||
where is the excel template located? | Excel Discussion (Misc queries) |