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