I have a web query for a page (company internal) that requires you to enter login information in a web based form. I'm curious how excel handle this in web queries?
When I first set up the web query and put in the final web page address, it redirects to the login page where I can log in with my details and then the page redirects to the one that I need, where I can then select the tables I want and hit 'import'. Then once that query is set up, refreshes seem to work fine for a while but eventually (after closing, re-opening the worksheet?) the previously set up web query will again get redirected to the log in page and fail.
I know that when you're in a web browser, once you log in to a page like this, you will stay logged in for the remainder of the session unless you explicitly log out. Does excel do this in web queries somehow?
I'm writing a VBA program which currently grabs the users login details via a userform and then uses that to provide their login info automatically to the login page URL which redirects to the one with the data that needs to be refreshed. But it gets annoying having to enter your login for every refresh. I'm wondering if I could ask for their login just the first time after the workbook is opened, and then all subsequent refreshes with that URL will automatically see excel as 'logged-in'. As far as I can tell, excel doesn't use a typical web browser for these queries, so I'm not sure how it works exactly.
When I first set up the web query and put in the final web page address, it redirects to the login page where I can log in with my details and then the page redirects to the one that I need, where I can then select the tables I want and hit 'import'. Then once that query is set up, refreshes seem to work fine for a while but eventually (after closing, re-opening the worksheet?) the previously set up web query will again get redirected to the log in page and fail.
I know that when you're in a web browser, once you log in to a page like this, you will stay logged in for the remainder of the session unless you explicitly log out. Does excel do this in web queries somehow?
I'm writing a VBA program which currently grabs the users login details via a userform and then uses that to provide their login info automatically to the login page URL which redirects to the one with the data that needs to be refreshed. But it gets annoying having to enter your login for every refresh. I'm wondering if I could ask for their login just the first time after the workbook is opened, and then all subsequent refreshes with that URL will automatically see excel as 'logged-in'. As far as I can tell, excel doesn't use a typical web browser for these queries, so I'm not sure how it works exactly.
