VBA Code to open a specific excel workbook from sharepoint that has a different title.

[bobbyleeds84]

Hi Guys,

Newbie to the forum here looking for some help with a macro.


I have got the below vba to open an individual workbook from sharepoint:

Sub grnreport()

Dim OutputFile As Workbook

Set OutputFile = Workbooks.Open("https://sharepoint.sharepoint.com/s... Reports/014_P_172_Pilot GRN Report v2.6.xlsm")

End Sub


This works great as long as I don't update the file with a new version number but as soon as the version number is changed (i.e. from v2.6 to v2.7) it won't work...which I understand why.

So I was just wondering if it is possible to make it so that it would open the workbook from sharepoint no matter what the version number is on the end of the filename?

Thanks in advance

Robert

 

[HackSlash]

Well, you need to be able to list the files on the sharepoint in order to do a filename partial match to string. Can you mount the sharepoint to a local drive letter? Then you could use FileSystemObject and it would be easy. Trying to do this with HTTP is inadvisable.

 

[chandrashekarshayana1]

as soon as you changed the file name in the sharepoint please change the

Set OutputFile = Workbooks.Open("​

https://sharepoint.sharepoint.com/si...rt%20v2.6.xlsm

") as well. I think this may work..
​