I've been searching through these forums to find a solution, but didn't manage to find a working solution (probably because I'm an Excel newbie). I would like to import data from a particular website into excel, but that page is protected by username & password: http://www.standaard.be/Registratie/Aanmelden.aspx?pad=/extra/economie/portefeuille.aspx%3flink%3dportefeuille/default.aspx Username field' name: ctl00$ContentPlaceHolder1$aanmeldBox$tbEmail Password field's name: ctl00$ContentPlaceHolder1$aanmeldBox$tbPassword I don't want to login again each time I'll import the data in Excel. Not sure what are the possibilities, user/pass stored in a cell, VBA script,.... Any help would really be appreciated!

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

New web query from username/password protected page

Thread starter nitroboy
Start date Nov 1, 2010
Tags

excel password username web query

nitroboy

New Member

Nov 1, 2010

I've been searching through these forums to find a solution, but didn't manage to find a working solution (probably because I'm an Excel newbie).

I would like to import data from a particular website into excel, but that page is protected by username & password:
http://www.standaard.be/Registratie...tefeuille.aspx?link=portefeuille/default.aspx

Username field' name:
ctl00$ContentPlaceHolder1$aanmeldBox$tbEmail
Password field's name:
ctl00$ContentPlaceHolder1$aanmeldBox$tbPassword

I don't want to login again each time I'll import the data in Excel. Not sure what are the possibilities, user/pass stored in a cell, VBA script,....

Any help would really be appreciated!