Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to install a new version of an Excel program - Import file does not allow replace to modules
caveat. I'm very new to VBA and excel. I've googled and researched in
a VBA book I have and did not find a resolution. I have an Excel program i've just completed containing 6 worksheets, 6 userforms and a number of modules with about 30 routines. Before I give this to the user I want to figure out means to install any future modifications made on my personal copy of the program to the user's without wiping out the data in the worksheets.. I can't just move in the new version as the data on the user's copy would be wiped out. I've tried using the Import file function but it does not allow the import of a module/form with the same name. Any suggestions on migrating updates into a user's copy of an Excel program/system? Thanks Bill Sacramento |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to install a new version of an Excel program - Import file doe
Probably best to separate you code and data to the maximum extent possible.
You can put your code (and any supporting worksheets) in an addin See this site for a discussion: http://www.jkp-ads.com/Articles/DistributeMacro00.htm -- Regards, Tom Ogilvy "billgeo" wrote: caveat. I'm very new to VBA and excel. I've googled and researched in a VBA book I have and did not find a resolution. I have an Excel program i've just completed containing 6 worksheets, 6 userforms and a number of modules with about 30 routines. Before I give this to the user I want to figure out means to install any future modifications made on my personal copy of the program to the user's without wiping out the data in the worksheets.. I can't just move in the new version as the data on the user's copy would be wiped out. I've tried using the Import file function but it does not allow the import of a module/form with the same name. Any suggestions on migrating updates into a user's copy of an Excel program/system? Thanks Bill Sacramento |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to install a new version of an Excel program - Import file doe
http://cpearson.com/excel/vbe.htm has sample code for deleting macros etc.
You could construct a mcaro that deletes the old and imports the new. -- Best wishes, Jim "billgeo" wrote: caveat. I'm very new to VBA and excel. I've googled and researched in a VBA book I have and did not find a resolution. I have an Excel program i've just completed containing 6 worksheets, 6 userforms and a number of modules with about 30 routines. Before I give this to the user I want to figure out means to install any future modifications made on my personal copy of the program to the user's without wiping out the data in the worksheets.. I can't just move in the new version as the data on the user's copy would be wiped out. I've tried using the Import file function but it does not allow the import of a module/form with the same name. Any suggestions on migrating updates into a user's copy of an Excel program/system? Thanks Bill Sacramento |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to install a new version of an Excel program - Import file doe
On Apr 10, 11:10 am, Jim Jackson
wrote: http://cpearson.com/excel/vbe.htm has sample code for deleting macros etc. You could construct a mcaro that deletes the old and imports the new. -- Best wishes, Jim "billgeo" wrote: caveat. I'm very new to VBA and excel. I've googled and researched in a VBA book I have and did not find a resolution. I have an Excel program i've just completed containing 6 worksheets, 6 userforms and a number of modules with about 30 routines. Before I give this to the user I want to figure out means to install any future modifications made on my personal copy of the program to the user's without wiping out the data in the worksheets.. I can't just move in the new version as the data on the user's copy would be wiped out. I've tried using the Import file function but it does not allow the import of a module/form with the same name. Any suggestions on migrating updates into a user's copy of an Excel program/system? Thanks Bill Sacramento- Hide quoted text - - Show quoted text - Thanks Tom and Jim I'll check into both options! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import file so that it is a actual csv file, no excel cell version | New Users to Excel | |||
replace character in txt file before import to excel | Excel Programming | |||
Export Import Modules File Name error | Excel Programming | |||
What program do I install to install office 2003 with no prior pro | Excel Discussion (Misc queries) | |||
we cannot install SOLVER for Excel in our Danish version | Excel Discussion (Misc queries) |