如何使用文件名的一部分打开SharePoint文件?
我有一个每年更新的文件(需求2016,需求2017等)
我当前将文件与SharePoint URL链接。
Set wb = ThisWorkbook
Set demandWB = Workbooks.Open("http INSERT URL Demand%20Plan%2016.xlsm")
我想在名称中找到带有"需求"的文件。
在上面的评论的帮助下,我找到了一个有效的解决方案。以下是通过SharePoint root目录中的文件名循环的代码,并打开一个类似于字符串名称
的文件Public Sub ListFiles()
Dim folder As folder
Dim f As File
Dim fs As New FileSystemObject
Dim demandwb As Workbook
Set folder = fs.GetFolder("//(SHAREPOINT URL)/GRS Demand Plan")
For Each f In folder.Files
If f.Name Like "GRS Demand Plan*" Then
Set demandwb = Workbooks.Open(f)
End If
Next f
End Sub