So I have a File System Object (FSO) copying a folder on a server that literally takes a minute or 2 to finish copying.
The issue is that Excel pends. The code literally stops in VBA on this line:
FSO.CopyFolder("FolderLocation")
and wont run any code passed it until the folder is completely finished. Is there a way to avoid this?
Like when you manually copy/paste a folder, a pop up window comes showing the percentage till it's done; and you can do other stuff while it's copying.
Is there a way to have excel tell windows to do it like that so it won't cause excel to stop?
Bookmarks