• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Automation with Web pages

ravikiran

Member
Hi Excel Gurus,

This is an automation issue I am trying to solve and seek help from experts in various forums.

I need my excel macro to do the following on Internet explorer (or chrome):
1. Open URL - Click This 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.
 
Back
Top