Automate downloading of a spreadsheet

Ui.Vision HowTo
1

From a user: “Hi I’m trying to automate the downloading of a spreadsheet from this website: FedWatch - CME Group

The procedure is: (a) Open the page, (b) click on “Downloads” on the left side bar, (c) click on “All upcoming meetings.”

I cannot make any progress on step ‘b’ - I have tried both click and xclick methods without success. Any pointers would be much appreciated”

2

Hello, we looked into this. XClick works fine, but the challenge is that the download button is not visible in the browser view by default. It is further down the page. Unlike the regular CLICK command, the visual XCLICK command needs to see the button.

→ To find and click on the button, here is the solution:

  • first click anywhere on the page (here the “FOMC” word) to set the focus on the page
  • then use XTYPE | ${KEY_PAGE_DOWN} to scroll down the page

This video shows the macro: