Need VBA to open and copy data from excel(.xls) file located in sharepoint/intranet with partial file name.

[jpatel1983]

The location in sharepoint is-

http://workspaces.abc.net.au/healthcare/op/AutomatedReports/

<colgroup><col width="72" style="width: 54pt;"><tbody>
</tbody>

Name of the file is-

shrinkage ovc yesterday2018-08-08T08-01-06-146

<colgroup><col width="72" style="width: 54pt;"> <tbody> </tbody>

The date format remains the same,just change with Today's date.
The bold underlined part is radom and changes everyday.

Thanks for your help