通过Excel VBA检查Sharepoint网站中文件夹的存在，如果不存在则创建 [英] Check for existence of folder in Sharepoint website via Excel VBA and if it does not exist to create

问题描述

我需要将Excel文档保存到Sharepoint网站进行共享，并且需要与Sharepoint兼容的代码.

我希望宏能够检查具有给定URL的文件夹，如果该文件夹不存在，则可以自动创建该文件夹.

我到MKDir的旧代码无法与新的共享点一起使用，因为它没有映射到我的网络.

解决方案

此论坛适用于SharePoint 2013本地产品，因为此问题与Excel VBA有关，建议您在适当的论坛上创建一个新主题.

我们建议适当发布信息的原因是，您将获得最合格的受访者群体，以及其他定期阅读论坛的合作伙伴可以分享他们的知识 或从您与我们的互动中学习.

感谢您的理解.

以下带有演示的链接，有关如何检查文件夹是否存在于SharePoint中以及是否不存在，然后创建文件夹使用VBA可以帮助您:

最好的问候，

Linda Zhang

I need to save excel documents to the Sharepoint website for sharing and needed a code that is compatible to Sharepoint. 

I would like that the macro be able to check for a folder given the URL and if the folder does not exist, to create it automatically. 

My Old code to MKDir is not working with the new sharepoint to cloud as it is not mapped to my network. 

解决方案

Hi,

This forum is for SharePoint 2013 on-premise product, as this question is more regarding to Excel VBA, I suggest you create a new thread on the proper forum.

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

Thank you for your understanding.

The links below with demos about how to check if folder exists in SharePoint and if not then create folder using VBA would help you:

https://stackoverflow.com/questions/19693588/vba-check-if-sharepoint-folder-exists

http://www.vbaexpress.com/forum/showthread.php?49833-vba-to-check-if-folder-exists-in-SharePoint-and-if-not-then-create-folder

Best Regards,

Linda Zhang

这篇关于通过Excel VBA检查Sharepoint网站中文件夹的存在，如果不存在则创建的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！