Hi all, I have a macro that will locate files in a folder, then it will copy the worksheets and paste into the current workbook.
However It need to open up to 100 workbooks and copy and paste into the new workbook. During the run of the macro, I can see files opening and closing on the toolbar. is that possible to make those opening and closing of files not seen by the user?
Pls Advise.
Sub RunCodeOnAllXLSFiles()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.EnableEvents = False
'Macro code to copy from multiple workbooks to current workbook
Application.ScreenUpdating = True
Application.DisplayAlerts = True
Application.EnableEvents = True
End Sub
Bookmarks