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- [TABLE="width: 54"]
<colgroup><col width="72" style="width: 54pt;"><tbody>[TR]
[TD="width: 72, bgcolor: transparent"]http://workspaces.abc.net.au/healthcare/op/AutomatedReports/
[/TD]
[/TR]
</tbody>[/TABLE]

Name of the file is- [TABLE="width: 54"]
<colgroup><col width="72" style="width: 54pt;"> <tbody>[TR]
[TD="width: 72, bgcolor: transparent"]shrinkage ovc yesterday2018-08-08T08-01-06-146
[/TD]
[/TR]
</tbody>[/TABLE]
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