Exporting modules

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am developing a user interface to handle their information stored in Excel
2003. Whenever I have new changes or I have a new version I want to export
all modules and then import them into the production Excel file.

Is there a way to export programmatically all Modules/Userforms/Class
Modules? I can do the importing manually (or is there a way to importing
them?)

Thx
 
In addition to the code on my site, I would recommend that you consider
separating data from code and put all your code in a XLA or COM Add-In. Then
when a code change is required, you need distribute only the Add-In to the
users. The data would remain safely isolated from the code so there would
be no versioning problems, security problems and the like. The production
workbook that contains the actual data need not be updated or redistributed.
See http://www.cpearson.com/Excel/CreatingCOMAddIn.aspx for COM Add Ins and
see http://www.cpearson.com/Excel/CreateAddIn.aspx for XLA add ins.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
Chip, that is actualy a better the way to go. I will look into that as soon
as I get a chance to do it. I am doing the interface as the user is entering
information -kind off changing the wheel on a moving vehicle.

Thank you so much guys!
 
Back
Top