Looping through files in a folder

  • Thread starter Thread starter Edgar
  • Start date Start date
E

Edgar

Hi

Is it possible to run a macro that will open a file in a
folder and then apply some code and then close that file
and open up the next in the folder.

For eg:

For x = file1 to file100 (folder c:\test\")
Workbook(x).open
'Some code here
Next x

TIA
 
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

Connect Files 4
Macro doesn't loop through sheets of books in specific folder 5
Looping through folders and using the first file in each folder 2
Print only the used sheets in all open files 2
Help - I'm getting desperate 7
Run macro on all files in a specific folder 3
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
copying cells from one file to another file 4

Back
Top