View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
geotelwoman geotelwoman is offline
external usenet poster
 
Posts: 1
Default Can I update vbaproject.bin in a package?

This sounds like what I want to do and the right direction for me to take,
but I'm not familiar with 'add-in's. I'm pretty much a novice. Where can I
learn more about add-ins?

"Jon Peltier" wrote:

You should redesign the package so the data is in a separate workbook, and
the code is in an add-in. This allows you to (a) use a single version of the
program with independent sets of data, and (b) update the code without
worrying about any of the data. It is possible to update the code in a
workbook, but it is complicated and requires certain permissions to access
the VB projects.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"geotelwoman" wrote in message
...
I would like to change the VBA programming in a workbook without touching
the
data. Can this be done by changing the vbaProject.com component within the
package?