LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default User Upgrade Procedures

How are you experienced developers coping with upgrading your clients?
Most, if not all, of my future changes will be in the Modules, not the
worksheets. My current upgrade plan is something like this:

1. Have client open both upgrade and old workbooks.
2. Upgrade will have single sheet containing a command button. Sheet
may also contain the macro code or a call to a module routine.
3. Button will copy old workbook sheets (some protected, some not) to
upgrade.
4. One copied protected sheet will require adjusting formulas that will
retain the identity of the old workbook's filename (gathers data from
other sheets). Upgrade code will do this.
5. Last act of upgrade macro is to delete the upgrade sheet (if
possible, not sure how this can be done yet if code is contained in the
sheet itself).

Your input is greatly appreciated....

mike

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cells User Select Locked after upgrade to Excel 2002 TWilson Excel Discussion (Misc queries) 1 August 5th 05 12:22 PM
Ontime procedures ironmouse[_4_] Excel Programming 3 June 13th 05 09:41 AM
VBA Sub procedures lexiez Excel Programming 2 October 4th 04 04:21 PM
what's wrong with this sub procedures? active_x[_4_] Excel Programming 8 September 10th 03 05:25 AM
VBA -- procedures as arguments? Dave Ring Excel Programming 1 August 27th 03 02:27 AM


All times are GMT +1. The time now is 09:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"