| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open file from website, where filename changes
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open FileName For Input As #FileNum2 - - - File Already Open! | Excel Programming | |||
| Find filename of open file | Excel Programming | |||
| Open File based on filename in cell | Excel Programming | |||
| want to download csv file from website and need to open in Excel. | Excel Discussion (Misc queries) | |||
| Can't open XL file on website in IE6 | Excel Discussion (Misc queries) | |||
Threaded Mode
