I made the following Macro, which used to work. Somehow it doesn't work completely.
It should open excel files and copy a specific Sheet to the Excel file containing the Macro on a Sheet with the same name. The Sheets are created, the files are being opened, the correct Tab and Range are selected, but somehow the data is not pasted. What am I missing?
HTML Code:
Bookmarks