R
Ryan H
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,
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,