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


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Jason" wrote in message ...
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.

"Ron de Bruin" wrote:

Hi Jason

Start here
http://www.rondebruin.nl/copy4.html
--
Regards Ron de Bruin
http://www.rondebruin.nl



"Jason" wrote in message ...
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.