Hello All

I am looking for VBA code that will do the following:

1 Open a 'file open' box so you can select a location and select multiple xlsx files
2 Open each file selected
3 copy the first worksheet in each selected file
4 Add those copied worksheets to an existing file
5 Close all of the workbooks except the one with the new copied worksheets

I have the following code with covers steps 1 and 2, but the issue I am facing is that the selected files take a long time
to open and also seem to slow down my excel

Please Login or Register  to view this content.
Thanking you in advance for any assistance

Thanks
Ghostly1