I am having problems copying information from a website via vba code
in excel. Its a secured site and I can enter the username/password
without error. The data that needs to be copied is on a popup window
that is opened once the correct button is selected. I can get the
popup to appear, but when I do a select all, it selects data from the
original window not the popup. Is there a way that I can select the
data from the popup window not the original. Thanks for your help.
The code that I use to create the original internet explorer window:


Set ie = CreateObject("internetexplorer.application")
With ie
ie.Visible = True
.Navigate "https://website"
Do Until Not .busy
DoEvents
Loop

I think maybe what you want is to set up a WebQuery instead.

=dman=

=====================
In .com,
spake thusly:

I am having problems copying information from a website via vba code
in excel. Its a secured site and I can enter the username/password
without error. The data that needs to be copied is on a popup window
that is opened once the correct button is selected. I can get the
popup to appear, but when I do a select all, it selects data from the
original window not the popup. Is there a way that I can select the
data from the popup window not the original. Thanks for your help.
The code that I use to create the original internet explorer window:


Set ie = CreateObject("internetexplorer.application")
With ie
ie.Visible = True
.Navigate "https://website"
Do Until Not .busy
DoEvents
Loop