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 -

Ron de Bruin shares lots of tips he
http://www.rondebruin.nl/tips.htm
look for "Copy/Paste/Merge examples"

cmac wrote:

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 -

--

Dave Peterson

Thanks so much - that works!

"Dave Peterson" wrote:

Ron de Bruin shares lots of tips he
http://www.rondebruin.nl/tips.htm
look for "Copy/Paste/Merge examples"

cmac wrote:

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 -

--

Dave Peterson