J
Jason
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/com...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 nam
http://investor.shareholder.com/com...1DF6&filename=US_Rig_Report_123109revised.xls
here is the website where the link is located:
http://investor.shareholder.com/bhi/rig_counts/rc_index.cfm
How might we automate opening this file as we were before?
Thanks!
site has begun re-naming this spreadsheet with specific names.
Before we were using:
Workbooks.Open
"http://investor.shareholder.com/com...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 nam
http://investor.shareholder.com/com...1DF6&filename=US_Rig_Report_123109revised.xls
here is the website where the link is located:
http://investor.shareholder.com/bhi/rig_counts/rc_index.cfm
How might we automate opening this file as we were before?
Thanks!