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 <(E-Mail Removed)>,
(E-Mail Removed) 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
>