for every workbook in folder

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

loop through the workbook and paste every sheet it into newly createdworkbook with same sheet name 2
Import multiple workbooks to current workbook in specified row number 0
Save each sheet of multi-sheet workbook as a single-sheet workbook 3
Move to every record on every worksheet 3
Create a workbook from every worksheet in your workbook 7
Data Update Loops between Folders 2
Macro for all Excel Workbooks to print to PDF 2
vba code does not run 3

Back
Top