PDA

View Full Version : VBA code to open IE in non-protected mode



paranidharan
08-09-2013, 11:42 AM
Hi,

I have a VBA code for IE automation which is causing issue with a few users who have IE8. On successive calls with them it is found that users are restricted to change the Internet Options -> Security settings for Protection mode.

The issue is as their IE runs on protective mode, when instantiating an IE object from macro code in an invisible mode and on transferring VBA form user credentials data to IE, it doesn't work. And when we change the settings of the IE to non-protective mode (unchecked the "Enable Protective Mode" option) it worked.

The problem is we can't instruct the user to change the settings and work, and moreover it's their company policy to restrict users to change IE settings. So only way is to fix through macro code, how to open an IE in non-protected mode with Medium security level for Internet Zone from VBA macro code?

Please suggest a solution.