Excel to Web Automation (Submit button Not Working)

**plasma33** · 05-12-2012, 09:29 PM

Hi Guys,

Here is what I am trying to do via Macro Automation->

-> I am trying to open the website http://www.metaboanalyst.ca/MetaboAn...faces/Home.jsp

-> Then clicking on the "click here to start"

-> Then checking the radio button for "Peak intensity table"

-> Then click on "Browse" the data file and select a file (http://www.mediafire.com/download.php?56pnxhb7aj9m5az) manually.

-> Then finally click on the submit button (which is not working and path to the file vanishes while clicking on the submit button and giving me an Automation error ['-2147352319 (80020101)'])

Here is the code that works fine except for the last step which is submitting->

Please Login or Register  to view this content.

Thanks in advance guys.

Cheers
plasma33

**abousetta** · 05-13-2012, 10:03 PM

I have been working on this for a while and to be honest it's not working for me either. It seems that the website is using some sort of javascript commands that I am unable to master. You will probably be better off getting help from a JavaScript forum at this point if noone else here is an expert on vba/html/js. I am bumping this thread in the hopes that some one with knowledge of js will be able to isolate the problem.

I have had to use some cloak and dagger approaches because it seems that if the automation is instanteous, the website rejects it. It might be some security measure to hinder automation, which is not surprising.

Here is what I have so far:

Please Login or Register  to view this content.

Also here is the file I had promised you before. I returns all the elements in an open IE webpage. I have run it for you and the results are presented. I hope that this helps you in finding a solution.

Good luck.

abousetta

**plasma33** · 05-14-2012, 03:50 AM

Thank you very much abousetta for the help. Really appreciated. Also the document you uploaded is really good stuff. Will try posting it in some js forums too. Wish me luck! Again thanks for your help mate.

**abousetta** · 05-14-2012, 03:54 AM

Glad I could of some assistance. Sorry I couldn't crack the code this time around.

Good luck.

abousetta

**Chippy** · 05-14-2012, 09:34 AM

abousetta's code works for me (IE8/Excel 2003). Here's my solution, which also works and is similar to abousetta's code. In your original code replace:

IE.Document.getElementById("form1:tabSet1:tab1:layoutPanel7:csvSubmitButton").Click

with:

Please Login or Register  to view this content.

**abousetta** · 05-14-2012, 09:39 AM

Chippy, it might be that I am using IE 9. I have found problems with lots of webpages because of this but at the same time don't want to go back to IE 8 and most automation code is designed for IE instead of Firefox or Chrome, etc.

I should probably think of getting IE8 set up on another system for checking if the problem lies with IE or the automation process itself.