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