Extracting embedded url via website's HTML code R

So I am trying to read the file named "North America Rotary Rig Count Pivot Table (Feb 2011 - Current)" into R. However, baker hughes changes the URL slightly each week so I cannot just copy and paste the URL to in my code. So my question is, is it possible to access the website's HTML code and find the location of the URL in R? If not, what is the best possible way to access the URL aside from going manually copying and pasting in the URL.

http://ift.tt/12c2bUN