使用MS Excel VBA访问SharePoint元数据 [英] Accessing SharePoint metadata using MS Excel VBA

问题描述

我希望能够使用MS Excel文件访问SharePoint库中文件的发布版本.该文件供不同的用户使用，因此我需要使用VBA对此文件进行编码，以使其对所有用户都起作用...有关如何执行此操作的任何想法?

I would like to be able to access the published version of a file in a SharePoint library using a MS Excel file. This file is used by different users, so I need to code this with VBA so that it is functional for all users... Any ideas on how to do this?

谢谢！

推荐答案

嗨柔柔，

您可以尝试以下脚本:

Dim SummaryWB As Workbook

Dim vrtSelectedItem As Variant

With Application.FileDialog(msoFileDialogOpen)

    .InitialFileName = "https://sharepoint.com/team/folder" & "\"

    .AllowMultiSelect = False

    .Show

    For Each vrtSelectedItem In .SelectedItems

        Set SummaryWB = Workbooks.Open(vrtSelectedItem)

    Next

End With

If SummaryWB Is Nothing then Exit Sub

这是一个具有类似要求的线程:

最好的问候，

张琳达

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