Please help with IE automation by VBA

Hi all ,



Hope all are doing grt



I am again struck with a piece of snippet , I am not sure how to approach with ie automation... somehow I managed to create code.. but the vain is that after autoamting iexplorer is opening with the site , but the user name and password its not taking and submitting

please help

thanx in advance

Please Login or Register  to view this content.

down I am mentioning the html codedat may help u !!

HTML Code: 

Hi,

Maybe try this:

Please Login or Register  to view this content.

If it doesn't work, try changing loginForm.user to just user loginForm.password to just password. If it still fails then please save the login page as an mhtml page and upload it so I can see the actual page.

Hope this helps.

abousetta

Also please edit your posts above. You are missing the closing tags for the vba and html codes. [CODE] ["/CODE"] and [HTML] ["/HTML"] without the quotation marks.

Hy abousetta

Thank you very much almost done a bit more issue is there at last line of snippet

Please Login or Register  to view this content.

Here getting run time error 91

object variable or block with variable not set

wat will be the issue? I tried to change the login keywords but did't work out!!






and
it is as per u said in last paragraph
' Username
While UName Is Nothing: Set UName = ieApp.Document.forms(0).all("user"): Wend

its working well!!

Hi,

Maybe try:

Please Login or Register  to view this content.

If not, then please save the login webpage as an mhtml file and upload.

abousetta

hi

still that error is there (Runtime 91)


I am attaching mhtml file please have a check on that

meta.zip

unable to upload as mhtml so zipped

thanks for ur valuable time and help...

hi one more error is coming now !!


err.png


what will be the cause , its not always but some times!

Thanks for uploading the mhtml file. It makes it a lot easier when I can test it from my end.

This seems to be working now:

Please Login or Register  to view this content.

As for your error message, it means that you closed the IE window before the code was done running. If you want you can put On Error resume Next at the top of your code right after the declarations but I personally believe that it causes more harm than good because you should want to know if errors occur and where they occur. But there are times when this comes in handy or if you are giving to someone to use. Then at least it doesn't work instead of a weird error message popping up that they don't understand what to do with.

Let me know if this solves your problem.

Thanks.

abousetta

P.S. Thanks for the positive rep

[CODE]

Thanks a ton , hope U help again lot of people@@ great awesome job

Thanks for the feedback and glad its working now.

Good luck.

abousetta

Hi Indhrui,

Even if your subject is related as per forum rules you should create a new thread for different requirement

Hello @Indhrui and welcome to the forum,

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Thanks.

abousetta

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.