Hello! I want to process a list of excel files in a directory. The start is a kind of menu in Excel. I already read and sorted the filenames. I want to open the first file, manually put a lot of data in, close and save it. Then I should return to the menu sheet and process the next one. This until the whole list is finished. Some things work, but after opening the first sheet, the macro stops because it cannot find variables.I think the problem is transferring the control to the opened file and wait till it is finished. Somebody an idea?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Processing xls files from another workbook
- Thread starter rover1956
- Start date
Similar threads
- Solved
- Solved
