wezred
05-05-2005, 12:35 AM
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.
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.