Hello everyone. I am trying to create a macro which opens several workbooks and copies a single worksheet out of them into my main workbook.
I already have working code for that task, however my macro is really slow when opening other excel files from my computer.
Here is my code:
Like I said: Workbooks.Open(...) takes really long (several minutes) and I don't know how to combat this.Please Login or Register to view this content.
Thanks everyone in advance!
Bookmarks