We were automatically downloading a spreadsheet from the web, but now the
site has begun re-naming this spreadsheet with specific names.

Before we were using:
Workbooks.Open
"http://investor.shareholder.com/common/download/download.cfm?companyid=BHI&fileid=309891&filekey=4 599F87A-DAE4-4912-A4E1-6E7A3B928F61&filename=US_Rig_Report_.xls"

Which used to work, but now they change the file ID, filekey and date. Here
is an example of the new file name
http://investor.shareholder.com/comm...9revised. xls

here is the website where the link is located:
http://investor.shareholder.com/bhi/...s/rc_index.cfm

How might we automate opening this file as we were before?

Thanks!