2 Files Open In 2 Instances Of Excel

[Celtic_Avenger]

Dave......

It works superb,

But however........when the code gets to the

Application.IgnoreRemoteRequests = True

part, it opens a pop up prompt window saying

"Existing Remote Links Will Be Terminated"

And then asks for an "OK" or a "Cancel"

Is there a way to stop this pop up from dissplaying?

Hope you can once again help.

Thanks

Celtic_Avenge

 

[Dave Peterson]

Untested, but maybe you could post back with your results...

With Application
.DisplayAlerts = False
.IgnoreRemoteRequests = True
.DisplayAlerts = True
End With