By using expertatexcel.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

Become an Σxpert at Σxcel.com

 


Application.IgnoreRemoteRequests

When running a batch spreadsheet, and say you try to open an excel email attachment nothing will happen because the first spreadsheet prevents the second from opening.

To allow the spreadsheet to open, in the batch spreadsheet you can set.

Application.IgnoreRemoteRequests = True

and any request to open a spreadsheet will occur in another copy of Excel.