If you do not press Cancel in the dialog that appears when the macro is executed, the process will not proceed.

This is a question about Excel VBA.
When you run the macro you created, the Downloading and Saving dialogs appear, and you must press the Cancel button to proceed.(See attached image)

I would like to know about the following two points.

Why does the Downloading, Saving dialog appear (not listed in the source)?
Why can't I proceed without pressing the cancel button

The following is the processing and execution environment for the created macros:

* Comparison source and comparison new files are located on the network drive.
It also specifies that the destination should be saved to a network drive.

Operating System: Windows 7 32-bit Memory: 4G Software: Excel 2013 32-bit

Regarding the cause of the dialog display,
Comparison source files, new comparison files are placed on the network drive, so
The Downloading dialog appears.
However, after several macro runs, the Downloading dialog may not appear.
The Saving dialog also appears because you have saved the comparison results file on your network drive.
After several macro runs, the Save dialog may not appear.

Downloading Dialog