Data Connection - auto logoff
Using Excel 2013 on Windows 10
Using Data Connections within macros to restore a set of data from an external website. This requires a SendKeys to 'Refresh' the Query each time as there is a log in page on the site before getting to the table required.
Before today (yesterday also on same OS/Excel version) the site would stay logged in and therefore, when I did a refresh, the correct table entry came back.
However, today, after the initial enquiry refresh (where you used to be able to log on and timeout would stop log out) and then Refreshing the data connection, I am only being returned the 'data' from the sites 'log on' page, i.e. the site has auto logged out and needs to log on, but has data connection cannot 'pause' whilst logging in I cannot retrieve my data.
|