Getting an error message as Object required-runtime error 424

[uday]

Hi Experts,

I want to automate a particular webpage through excel. I have written the coding strings to automate it, but still something missing which I do not know. I need your help.

The error message is reflect as Object Required. Please help.

Advance thanks.....

 

[Marc L]

Hi,

message means object does not exist …
​

 

[uday]

Could u please help me for this problem. Actually I do no know how to solve it.
and also I can not execute the login button.Please help

 

[Marc L]

In which line error occurs ?

Just check object …
​

 

[uday]

It not line specific...
Code is:-
Sub FillInternetForm()
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
'create new instance of IE. use reference to return current open IE if
'you want to use open IE window. Easiest way I know of is via title bar.
IE.Navigate "https://my.statestreet.com/main-smp...GET=-SM-https://my.statestreet.com/login/home"

'go to web page listed inside quotes
IE.Visible = True
While IE.busy
DoEvents 'wait until IE is done loading page.
Wend
IE.document.all("LOGIN").Click



End Sub

 

[Marc L]

An error is always line specific ‼

This error just means an object is called but does not exist …

So in step by step mode hit F8 key to find out bad codeline.
Once found, check out in source webpage code the object …
​

 

[uday]

I am getting this error message for first line.
[/quote]

 

[Marc L]

In step by step mode, line is yellow highlighted !

If error really occurs in first line, try on another computer …​