Open successive files in a directory

C

cmac

Hello,

I need help as I am not a programmer. I have created a macro (recorded)
that will open a specific filename, unhide a sheet, copy some cells and
pasted those cells in the next available row in the spreadsheet the macro is
run from. My issue is that the filenames (20 or more of them) are not
constant. Is there a way to have the macro open the first file in a
directory, execute the steps noted above in the macro, close the file and
then open the next file in the directory and so on? I would appreciate any
help you can provide.

Thank you -
 

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

Update Directory Path in Code 4
Open and Save Files in Directory 1
i need 1 macro button in master file to refresh data from all files 0
Directory Name - IF Named Range Exists 0
Open Workbooks present in the same directory 3
List Filenames and Date Modified 2
Listing the files from a directory 2
Run macro from directory folder...? 2

Top