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
IgnoreRemoteRequests bypassed!
-
- Administrator
- Posts: 78493
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: IgnoreRemoteRequests bypassed!
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.
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.
Best wishes,
Hans
Hans
-
- NewLounger
- Posts: 2
- Joined: 12 Feb 2010, 15:51
Re: IgnoreRemoteRequests bypassed!
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
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