使用Excel VBA进行Sharepoint访问 [英] Sharepoint Access with Excel VBA

问题描述

您好，我需要帮助使用excel vba从Sharepoint访问指定文件夹中的文件。

Hello, I need help with accessing files within a specified folder from Sharepoint using excel vba.

我尝试使用FSO对象但未成功（下方）

I tried using the FSO object without success (below)

Set oFSO = CreateObject("Scripting.FileSystemObject")
    Set oFolder = oFSO.GetFolder(sPath)
    Set oFiles = oFolder.Files

我已经设法通过将Sharepoint文件夹映射到驱动器号来获取文件夹中的文件，但我对这种方法有点担心。

I have managed to get the files in the folder by mapping the Sharepoint folder to a drive letter, but i am a bit wary of this approach.

还有其他方法吗？

谢谢

推荐答案

尽管Access在Arpanet启动后诞生，但仍然没有创造出对http的期望。因此，您在那里使用的代码适用于旧式Windows文件系统。所以，事实上他们已经设法扩展它，你甚至可以调查
一个http文件夹是相当不错的。

Despite Access being born after the start of Arpanet, it was still never created with the expectation of http. So, the code your using there is for old school Windows file systems. So, the fact that they've managed to extend it such that you can even investigate an http folder is pretty good.

几年前我用SOAP写了一些东西操作本地计算机上的SharePoint文件，但我相信这些代码远远少于强迫某人只绘制网络驱动器的代码。

A couple years ago I wrote something using SOAP to manipulate SharePoint files from a local machine, but I trust that code far less than I would forcing someone to just map a network drive.

这篇关于使用Excel VBA进行Sharepoint访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！