Object or with block not set

S

sidw0501

Can anyone help me solve this "Weird" problem. Here's my Code:

Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application")
ie.Visible = True
Range("A1").CurrentRegion.SpecialCells(xlVisible).Select
Selection.Copy
ie.Navigate URL:="https://live.lehman.com/EPW/loadpage.jsp?force=true"
Do Until Not ie.Busy
DoEvents
Loop

' creates data object
Set MyData = New DataObject
'gets data from the keyboad and stores it in the string
object

MyData.GetFromClipboard
Dim GetOffClipboard As String
'It gets Value from the clipboard and paste it in '
'the text area of the lehmanlive website

GetOffClipboard = MyData.GetText()
'Error is shown in next line of code, most of the time
(ERROR IS MARKED here) ie.Document.all.Item("tickertextarea").Value
= GetOffClipboard
'automatically clicks the buttom1 buttom.
ie.Document.all.Item("buttom1").click()

But I am going through some kinda on and off error. sometimes the code
runs perfectly fine. But for most of the time,in the aboved-marked
line the error occurs saying:
OBJECT VARIABLE OR WITH BLOCK VARIABLE NOT SET

I trying several different approach, but in vain
Help in this case greatly appreciated!!
 

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

Similar Threads

Handle Pop-Up While Navigating with IE 0
Getting inconsistent Error 91-Object variable or With block variable not set 0
Object variable or with Block variable not set 9
Runtime error 91: Object variable or With block variable not set 8
Error 91 with IE object in Excel 2
If Cells.Find returns run-time error '91': Object variableor With block variable not set 1
Object variable or With block variable not set 2
object variable or with block variable not set 2

Top