我通常使用这段代码来检索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登录。
https://stackoverflow.com/questions/1344910
复制相似问题