×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Object doesn't support this property or method

Object doesn't support this property or method

Object doesn't support this property or method

(OP)
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

RE: Object doesn't support this property or method

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close