Hey all!
I have been looking at methods to refresh data from a website where you need to login and I have seen a few ways of doing this. I know it does vary from site to site and of course my preferred method, but at this point I am looking for advice on the best possible solution to my issue.
I want to log into the website http://www.metroho.com/ and pull fresh data from specific tables. I have done this with the Web Query builder but when re-openeing the spreadsheet, I have to recreate that connection by logging in with the web query.
So really what I need is a way to re-create the web query connection and refresh the data either using a macro or each time the sheet is opened.
My first approach was to create the IQY file, call the IQY from a form button and send cell variables as the login info, then refresh the requested tables, all with the click of one form button. Next was to use macros. Truthfully, I have no preference on method, just looking for the spreadsheet to take two cell values to login to the site with then refresh 5 - 10 tables automatically. Any help would be appreciated.
Edit: Forgot to mention I am using Excel 2007.
Here is the contents of the iqy. Basic I know, but I'm not looking for complicated. I'll tweak it all once the function is there.
I have been looking at methods to refresh data from a website where you need to login and I have seen a few ways of doing this. I know it does vary from site to site and of course my preferred method, but at this point I am looking for advice on the best possible solution to my issue.
I want to log into the website http://www.metroho.com/ and pull fresh data from specific tables. I have done this with the Web Query builder but when re-openeing the spreadsheet, I have to recreate that connection by logging in with the web query.
So really what I need is a way to re-create the web query connection and refresh the data either using a macro or each time the sheet is opened.
My first approach was to create the IQY file, call the IQY from a form button and send cell variables as the login info, then refresh the requested tables, all with the click of one form button. Next was to use macros. Truthfully, I have no preference on method, just looking for the spreadsheet to take two cell values to login to the site with then refresh 5 - 10 tables automatically. Any help would be appreciated.
Edit: Forgot to mention I am using Excel 2007.
Here is the contents of the iqy. Basic I know, but I'm not looking for complicated. I'll tweak it all once the function is there.
Code:
WEB
1
[URL]http://www.metroho.com/login.php[/URL]
emailintro=emailaddy@email.com&passintro=password
Last edited:
