PC Review


Reply
Thread Tools Rate Thread

Advantages and Disadvantages of Referencing An Add-In Workbook

 
 
Ryan H
Guest
Posts: n/a
 
      22nd Mar 2010
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?

--
Cheers,
Ryan
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Advantages and Disadvantages of Referencing An Add-In Workbook Ryan H Microsoft Excel Programming 0 19th Mar 2010 01:57 PM
Advantages & Disadvantages of IE pradeep Windows XP Internet Explorer 2 8th Jun 2007 02:03 AM
What are the advantages and disadvantages of using MP3. Bernie Windows XP Music 7 8th Sep 2004 09:12 PM
SP2 RC2 - advantages, disadvantages? Swingman Windows XP Beta 2 11th Jul 2004 11:18 PM
advantages & disadvantages carmen cho Microsoft Windows 2000 2 28th Aug 2003 09:25 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:51 AM.