IgnoreRemoteRequests bypassed!

[foilage]

Hi All,

Hope someone can help with this one...

I've got an excel app which runs hidden in the background and uses Application.IgnoreRemoteRequests = True to stop Windows from hijacking the session to display a workbook being opened for example. Unfortunately, there is a particular web-app which exports a table of data as a "web page" (or at least this is the default format which excel wants to save it as) and this somehow manages to get around the IgnoreRemoteRequests setting and unhide my app's excel session.

Has anyone come accross this before and have a solution?

Thanks!
Bruce

[HansV]

Hi Bruce,

Welcome to Eileen's Lounge!

The IgnoreRemoteRequests property ony affects DDE requests (double-clicking an Excel file in Windows Explorer generates such a request); it does not prevent another application from using Automation to control your instance of Excel. I'm not aware of a way to disable Automation.

[foilage]

Hi Hans,

Thanks for the info. Bummer about the inability to avoid automation. I'm going to try using a dummy (empty) excel session as a shield that can hopefully take the hit... will post if this proves successful.

Thanks again,
Bruce