for every workbook in folder
 

I have many workbooks in a single windows folder
They are all identical in structure but contain different data

I need to paste some data into each from a single source sheet

what I really would like is a routine which does a loop

For every workbook in folder
Open workbook
Paste in data
Save and Close workbook

Is such a loop possible ? How?

Many thanks


--
Patrick

for every workbook in folder
 

Hi Patrick

Try this
http://www.rondebruin.nl/copy4.htm

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


"Patrick" wrote in message ...
I have many workbooks in a single windows folder
They are all identical in structure but contain different data

I need to paste some data into each from a single source sheet

what I really would like is a routine which does a loop

For every workbook in folder
Open workbook
Paste in data
Save and Close workbook

Is such a loop possible ? How?

Many thanks


--
Patrick

for every workbook in folder
 

Ron

wow - really helpful - working already

Thank you

Patrick


"Ron de Bruin" wrote:

Hi Patrick

Try this
http://www.rondebruin.nl/copy4.htm

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


"Patrick" wrote in message ...
I have many workbooks in a single windows folder
They are all identical in structure but contain different data

I need to paste some data into each from a single source sheet

what I really would like is a routine which does a loop

For every workbook in folder
Open workbook
Paste in data
Save and Close workbook

Is such a loop possible ? How?

Many thanks


--
Patrick