View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kaisies Kaisies is offline
external usenet poster
 
Posts: 10
Default Excel Add-Ins... Distribution and Overwriting old Versions

I have a Workbook that uses an Add-In for all its code, Buttons in this
Workbook just call procedures from the Add-In to do their things.. Now I
want to change some of the code in the add in... I have the new add in, and
I know that to overwrite the old one I first:

Open Excel, create a new workbook
Uncheck the box in the Tools... Add-Ins Menu for the Add-In
Open the .xla file
Then re-check the Checkbox in Tools.... Add-Ins

But, opening the new .xla file doesn't seem to overwrite the old one!

I would very, very much like to not have to have the user have to Save the
e-mail attachment (how I will distribute the new add-in) as the /Application
Data/ folder is hidden and it takes about 20 steps and 15 minutes to save it
to the proper directory (most of the people that get this new add-in know how
to send e-mails and very little else), and then I have to do that times 21
users...


Thanks for the help!