After Opening a Networked Excel File the Downloading Progress Dialog Does not Clear RRS feed

  • Question

  • I am running Excel 2013 on Windows 7

    My macro is looping round the Excel files on another PC in my home network. Opening them, processing them and then closing them.

    If a file is slow to download to my PC the Downloading Progress dialog is displayed. After the file has successfully downloaded to my pc, the Dialog Box should be Cleared - it is not. Any ideas?

    Wednesday, August 23, 2017 9:34 AM

All replies

  • It would probably help to see your code. If I were to guess, it sounds like the main thread is too busy to enable the dialog box to close. Perhaps you need a DoEvents statement within your loop to free up some time for this to occur.

    Paul ~~~~ Microsoft MVP (Visual Basic)

    Wednesday, August 23, 2017 1:26 PM