View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ryan H Ryan H is offline
external usenet poster
 
Posts: 489
Default 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