Disable Password/Login Request on Web Query

[wezred]

I've set up my macro to open a website in excel in order to extract information from it. It works especially well with ASP and PHP websites where using the standard Web Query Import would fail.

I'm now facing a problem with some website prompting me with a login box, like the ones you get when going into a https site. However, if i were to click cancel on this box, the page would still be displayed and i can access the information i need. Trouble is I can't seem to program the macro to click cancel automatically.

Further to this, can i also program the macro to key in the login name and password if needed, automatically?

Workbooks.Open("https://....") is the function i used.

Thank for the help.

[santhoshkv]

Hi,
Share us the snap shot of the login window that populates, so that we get a idea.

[Simon Lloyd]

Sounds like you are trying to access a page or data that resides in a password protected folder as actual https websites will not display the page if you do not have the password, folder security as you are describing displays that behaviour, however, clicking cancel may get you to view the item but performing another action will cause the login pop up again which will cause you further problems.