Mulitple HTMLdocuments

[Tgaboreau90]

Hello,

If i want to pull data from a website i do this....

Dim ie As New InternetExplorer

  ie.Navigate "www.example.com"

  Dim doc As HTMLDocument

Set doc = ie.document

Dim sSS As String

sSS = doc.getElementsByTagName("Table")(0).innerText

ActiveCell.Offset(0, 1) = sSS

but what do i do if i then want to navigate to a second website and pull data from there?

because whatever i do my code only pulls data from the first website.

i've tried...

  Dim doctwo As HTMLDocument

Set doctwo = ie.document

and various other things, but can't get it to work.

i'm a beginner at vba as you can probably tell.

please help.

 

[Kyle123]

Maybe like this:

Dim ie As New InternetExplorer

  ie.Navigate "www.example.com"

  Dim doc As HTMLDocument

Set doc = ie.document

Dim sSS As String

sSS = doc.getElementsByTagName("Table")(0).innerText

ActiveCell.Offset(0, 1) = sSS

  ie.Navigate "www.example.com"

Set doc = ie.document

sSS = doc.getElementsByTagName("Table")(0).innerText

ActiveCell.Offset(0, 2) = sSS

 

[Tgaboreau90]

This just keeps the original web page as the document

 

[Kyle123]

have you changed the second url?

 

[Tgaboreau90]

just realised what it was.

wasn't using do events so it was redefining the document before the url had even changed. silly me.

cheers for your help.