通常我使用以下代码在VBA中检索文件夹内容。但在SharePoint上不起作用。我该怎么办?
Dim folder As folder
Dim f As File
Dim fs As New FileSystemObject
Set folder = fs.GetFolder("//sharepoint.address/path/to/folder")
For Each f In folder.Files
'Do something
Next f
编辑(在shahkalpesh的良好评论之后):
如果我在Windows资源管理器中输入地址,就可以访问SharePoint。访问SharePoint需要身份验证,但它是透明的,因为它依赖于Windows登录。