Use VBA to Automate Actions on Webpage (Open web page, Select Dropdown, click button)

Hi Excel Gurus,

This is an automation issue I am trying to solve and seek help from your expertise.

I need my excel macro to do the following on Internet explorer (or chrome):
1. Open URL - Link
2. Select Dropdown - "M-Option on UK Natural Gas NBP Future"
3. Click on Submit
4. There will be 7 Download links that I need to download (All PDF's)

I tried to find out the download links and hard-code the macro, which didn't work probably due to JAVA API (I am not sure about this).

I am just hoping there will be someone who had experience with this sort of automation.

Thanks in advance.

Cheers,
Ravi.

Hi RAvi,

Use below code:

Please Login or Register  to view this content.

Cheers!!

Did this helped???

Hi Excelliot,

Apologies for my late reply. I just checked I received help from you Thanks for your help.

I did give this a try and it did work for the first part of navigating to the Reports (M-Option) downloads page. after which it gets stuck. (I think this might be because of a different version of IE). Will test again on my home PC.

In the meantime, I have been busy trying the same alternative with Selenium Webdriver, which did work to download the files. Though, I am unable to navigate to the M-option reports page. So I am downloading the reports with "All Contracts" and extracting required M-Option out of it. This is a tiresome process as the download files are quite quite heavy (more than 5 MB).

Please check the code and see if you can help me complete it. This needs Selenium Wrapper Type Library which can be downloaded at this location: Link

Please Login or Register  to view this content.

Thanks again for your help.

Cheers,
Ravi.

Hi Ravi,

Try code i gave, if you find difficulty then we can modify code, this could be majorly due to tab event in your IE, check for that & correct it..

Cheers!!

Thanks Exelliot. I had some issues with the IE, due to the different versions available on user machines. Though the code is work on few machines. I did go with using the Selenium webdriver and proceed with the model.

Thanks again for all your help. Your code did help me find more ideas to get to the final solution. I am marking this solved.

Shall I post the final working code?

cheers,
Ravi.

yes..


Cheers!!