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?