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.
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.