Copying from internet explorer

A

ajbarilla

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
 
D

Dallman Ross

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

=dman=

=====================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top