Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Object doesn't support this property or method

Status
Not open for further replies.

Jer1983

Technical User
Nov 30, 2016
12
US
Hi, I have a vbs script that takes values from an excel sheet and enters them into a website but when I hit a while condition I get a runtime error 800a01b6...When it hits the below with statement it errors out.

With IE.document
.all.View.Click
End With



Dim xl,xlwb

Set xl=CreateObject("Excel.Application")
xl.visible=TRUE
set xlwb=xl.WorkBooks.Open("workbook")

Set wshShell = WScript.CreateObject ("WSCript.shell")
Set IE = CreateObject("InternetExplorer.Application")
IE.visible = true

..
..
..
..

url=urlstart+xl.cells(i,2)+urlend

IE.navigate2 url

While ie.Busy = True
WScript.Sleep 100
Wend
While ie.ReadyState <> 4
WScript.Sleep 100
Wend

WScript.Sleep 500

With IE.document
.all.View.Click
End With
 
Code:
.all.View.Click
??

What exactly are you trying to achieve here?

"Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family." (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top