Advantages and Disadvantages of Referencing An Add-In Workbook

R

Ryan H

Let me give you some background information first. I have a workbook (Quote
Generator v3.xls) that references an add-in workbook (QG Add-In v3.xla).
The Add-in workbook contains macros to manipulate data in the Quote workbook.
So when the Quote workbook is opened the Add-In workbook is opened hidden
from the user. I should also note that both of these files saved on a
server, thus several sales people use them.

Here is my question. When a user opens a Quote workbook the Add-In is
automatically opened. If I need to make updates to the Add-In, because of a
"bug" that I fixed, I currently have to tell the entire sales team to close
out Excel completely, do the update, then tell them its ok to continue. This
is not desireable. Is there a way to overwrite the Add-In workbook even if
someone may be using it? If not, anyone have any other ideas?

I was thinking of removing the reference to the Add-In, putting code in the
Quote workbooks Open Event to open the Add-In workbook as Read Only, and then
set the reference to the add-in. Does anyone know of any disadvantages of
doing it this way before I spend time writing code on this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top