2 Files Open In 2 Instances Of Excel

  • Thread starter Thread starter Celtic_Avenger
  • Start date Start date
C

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
 
Untested, but maybe you could post back with your results...

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