creating patches

[viper]

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?

 

[Norie]

What sort of changes are you making?

Is it changes to code?

 

[Smitty]

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