using macro to open every file in a folder

  • Thread starter Thread starter wraithlead
  • Start date Start date
W

wraithlead

I need to open a file, copy a few lines and close it. then open th
next. I know how to do all that except getting the loop to open th
next file automatically. The trouble is that i don't know how man
files might be in the folder. it might be 4 or 5, but it might be up t
10 or 11.

any suggestions?

thanks,
richar
 
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

Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
Macros problem closing another file 0
SubFolders in macro 2
Macro to open file 2
Opening a list of Excel files and run a macro in each 17
How to browse folder and open xls file automatically in vba? 6
Opening Excel File from value in active cell 2
Run A Macro Every Time Excel opens any file 11

Back
Top