Linking Files - copy a worksheet to a new workbook
 

Is there a way to open several files one a time, copy data, run an update,
print and save over the file originally opened so that the vb code is updated
and the data remains the same. I have hundreds of files that need updated
that are all set up exactly the same and its a pain to update the code in
each file. Thanks.

Linking Files - copy a worksheet to a new workbook
 

Use this example
http://www.rondebruin.nl/copy4.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Kiba" wrote in message ...
Is there a way to open several files one a time, copy data, run an update,
print and save over the file originally opened so that the vb code is updated
and the data remains the same. I have hundreds of files that need updated
that are all set up exactly the same and its a pain to update the code in
each file. Thanks.