I'm guessing something changed here between Excel 2003 and Excel 2007.
I have an existing VBA macro that grabs some tables from a website that requires you to be logged in.
With Excel 2003 I achieved this by first creating an instance of Internet Explorer (InternetExplorer.Application) and using that to negotiate the login pages & check the 'Remember Me' box etc.
Once all of that was complete my VBA code then closed the IE instance, did some work in the workbook, and then ran the QueryTable.
When Excel ran the QueryTable it presumably used the same cache / cookies (or something else?) as IE, and I was able to grab the tables that I required.
The same macro running under Excel 2007 still manages to create the IE instance and log in etc, however when I come to do the QueryTables Excel reports that the conenction ot the server was successful, but the data was not available, which is what I would expect IF it hadn't logged in correctly.
I can only assume at this stage that the 'Query' from the QueryTables is appearing to the website as a different connection to the one established by the IE instance.
What changed?
What is the work around? (I'm presuming that there IS some way to access pages behind a login screen using 2007!)
In both cases the PC was WinXP SP3 with IE8.
Thanks
Bookmarks