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?