stanl
08-18-2005, 12:57 PM
I am helping a friend (this means I'm not being paid) access a secure site to gather vehicle sales statistics (note: he is a site member w/login and pw - so there is nothing sketchy here).
Because what he wants involves multiple Web-querys with 1-n sheets per workbook, I am using the InternetExplorer.Application Object to navigate to areas and then sending each .Document.Body.CreateTextRange.HTMLText to a temp file which is then processed by Excel as a web query. Several of the tables in the pages of interest have 'detail' which involves a Javascript pop-up.
Since my Object (oIE) is focused on the main table - how can I access the HTML of the pop-up.
Hope this makes sense.
Stan
Because what he wants involves multiple Web-querys with 1-n sheets per workbook, I am using the InternetExplorer.Application Object to navigate to areas and then sending each .Document.Body.CreateTextRange.HTMLText to a temp file which is then processed by Excel as a web query. Several of the tables in the pages of interest have 'detail' which involves a Javascript pop-up.
Since my Object (oIE) is focused on the main table - how can I access the HTML of the pop-up.
Hope this makes sense.
Stan