SQUIDD
Well-known Member
- Joined
- Jan 2, 2009
- Messages
- 2,090
- Office Version
-
- 2019
- 2016
- Platform
-
- Windows
Hi all
I want to open 6 internet explorer pages and grab data.
in my code below i have a for loop a = 1 - 6.
what is the correct way to use my a(1-6) as the new ie page.
so the part in the code should be something like "ie" & a that would equal ie1 on the 1st loop.
Thanks for looking. Im ok with everything else, just not sure on the syntex for the a(1-6)
I want to open all the pages 1st, then go back to ie1 and send keys then ie2 etc
this way my data has time to load before i finally return to grab the loaded data.
Dave
I want to open 6 internet explorer pages and grab data.
in my code below i have a for loop a = 1 - 6.
what is the correct way to use my a(1-6) as the new ie page.
so the part in the code should be something like "ie" & a that would equal ie1 on the 1st loop.
Code:
Sub download()
Dim ie As InternetExplorer
For a = 1 To 6
Set ie(1 - 6) = New InternetExplorer
With ie(1 - 6)
.Visible = True
.Navigate "web page"
Do While ie(1 - 6).Busy: DoEvents: Loop
Do While ie(1 - 6).ReadyState <> 4: Loop
End With
Next a
End Sub
Thanks for looking. Im ok with everything else, just not sure on the syntex for the a(1-6)
I want to open all the pages 1st, then go back to ie1 and send keys then ie2 etc
this way my data has time to load before i finally return to grab the loaded data.
Dave
Last edited: