Updating Multiple Workbooks

[Guest]

I have a file which serves as a master template. Over time, I have used this
for several workbooks which contain financial data on companies, and
therefore now have over 100 different workbooks based off this template. The
problem now is that the master template had to be updated, and I need the
changes to be reflected in each of the workbooks saved under the old
template.

The updates that need to be made are fairly simple, and mostly include new
values or formulas in cells. What I would like to do is have the master
template workbook open, and then have some code that will go through all
workbooks in a directory one by one, open each workbook, and copy certain
certain cells (let's assume Cell A1 on Worksheet 1 and Cell B2 on Worksheet 2
for this example) from the master template to the old file with the outdated
template.

Is this difficult to do. I would appreciate any code that could be provided
to accomplish this. Thanks.

 

[Ron de Bruin]

Hi Jason

Start here
http://www.rondebruin.nl/copy4.htm

 

[Guest]

Thanks Ron, this is very helpful. A follow up question... Is it possible to
also transfer VBA modules as well. For example, assume I have a module which
contains the old code, but I have since updated that code in the same module,
can I use code to delete the old module and transfer the new module to the
old workbook. If so, what would the code look like? Also, I assume if I
have code in a worksheet and I use the code you provide to move the
worksheet, the associated code will also get transferred with it. Is that
correct? Thanks.

 

[Guest]

Thanks Ron, this is very helpful. A follow up question... is it also
possible to use code to transfer modules which have been updated as well?
Also, if I were to use the code which you provided to copy sheets, would the
VBA code that is stored directly in that sheet also be transferred? Thanks

Jason

 

[Ron de Bruin]

Hi Jason

If you use the sheet option it will copy the sheet code also.
For changing the module code look at Chip Pearson's site
http://www.cpearson.com/excel/vbe.htm

If you need more help post back

 

[Guest]

JAson or anyone, i to have several worksheets in excell, i updated formulas
in my main template is there an easy way to update the formulas in the old
worksheets easily or do i have to manually update each one. i read answers to
jasons problem but i dont really understand them. help