Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open successive files in a directory
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 - |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open successive files in a directory
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open successive files in a directory
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
open all files in directory | Excel Discussion (Misc queries) | |||
Open files in the same directory | Excel Discussion (Misc queries) | |||
Open files in directory | Excel Programming | |||
Open files from specific directory | Excel Programming | |||
Open all files in a directory | Excel Programming |