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

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?