creating patches

viper

Active Member
Joined
Feb 15, 2002
Messages
382
Hello all,

Not to make this a real long post, I have out several worksheets in my company. When I need to make a change on one of them it becomes a hassle to send the new workbook out and the users then have to re-enter all the data into the new one.

My thoughts are, is there a way that I can create a patch workbook? Something I could send to them, they click a button and the patch workbook makes the changes I need to the specified workbook.

Has anyone done this before and if so have some stating code?
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,318
Office Version
  1. 365
Platform
  1. Windows
What sort of changes are you making?

Is it changes to code?
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
I do it all the time with Monthly program updates.

Using a Worksheet_Open event, do your thing, then close the workbook.

I'd be happy to send you the one I use the most if you want a visual, just PM me your e-mail address.

Smitty
 

Forum statistics

Threads
1,147,510
Messages
5,741,574
Members
423,668
Latest member
Audorin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top