Open a secured website using Excel VBA

[Inkarr]

I am trying to open a webpage that requests a user id and password, before the page loads.

The webpage is on a private network so i can't even show an example i'm afraid.

Basically there is a webpage per page server, there are 40. I go to each url, enter the log on details, the page is displayed, i shut down and move onto the next webpage and repeat.

I have seen loads of vba code to enter passwords however these only seem to deal with webpages that load and have a logon box on the page, not one that asks for credentials, through a new window, before it completes the page load.

Anyone any ideas? Completely stuck

 

[Inkarr]

Sorry i am running MS excel 2003 on Windows 2000

 

[John_w]

What is this window that is asking for the login credentials? Is it an IE window? A Javascript window? Is it a Windows login window or something the web server displays? Or something else? Can you find an example of the same login window on the internet?

There's code at http://visualbasic.about.com/od/standalonevb6/l/blnewieinstance.htm which uses WithEvents to handle the creation of an IE child window or new window, but it's unclear if that is what you have here.

SendKeys might work:

AppActivate "Title of the login window"
SendKeys "YourUsername"
SendKeys "{TAB}"
SendKeys "YourPassword"
SendKeys "{Enter}"

 

[Inkarr]

Thanks for the reply John.
I believe it is an IE window. It seems to work the same as a FTP server page request. ftp://ftp.applabs.com/.
The window i see isn't quite the same, in that it has fields, site, realm, username, password as in a server logon page, but it is the same as the ftp one in that it pops up before the page will complete, if correct user details are input.

 

[Legacy 98055]

Probably the windows security dialogue. I don't think you can access that one with send keys or the api but I could be wrong... I'll look into later.

 

[Inkarr]

This is the description of the window that pops up when the URL is requested. I hope it makes sense?

*Window Title*
Enter Network Password
*Information in the popup box*
Please type your user name and password
Site: ******
Realm Dynamo Admin Server
User Name (This is what i need to populate)
Password (This is what i need to populate)
OK Cancel

If i input the wrong details or cancel the following msg will be displayed:
HTTP Status 401 - You have requested data that requires authorization to access. Either your authorization was rejected or you need to authenticate yourself before you proceed.

 

[Inkarr]

Thanks guys. It will be the windows security dialog.
I've wrote a script in QTP that will do what i need to do but not everyone here has access to the machine or knows how to use it. I was hoping to put something together using excel vba, but it may not be possible.

 

[Legacy 98055]

Can you call your script from VBA? What is QTP?

 

[Inkarr]

QTP is Quick Test Professional, an automated testing tool by HP. Unfortunately it only resides on one Virtual Machine here, hence me trying to write a macro in excel that anyone here could use. QTP code is written in VB script.
With QTP being on a virtual machine that requires additional logon rights i can't call it from the excel macro