VBA创建SharePoint文件:上传失败 [英] VBA Creates SharePoint Files: Upload Failed

问题描述

我使用VBA从SharePoint下载文件，更改其中的一些内容，然后将其另存为SharePoint上的另一个文件名.这已经运行了6到7年，但是最近我开始遇到问题.文件将显示在上传中心中 标记为上传失败".文件必须检出".它们显示在Internet Explorer中，已签出给我，但我无法签入.我唯一能做的就是:

I use VBA to download a files from SharePoint, change a few things in it and then save it as a different file name back on SharePoint. This has worked well for 6 or 7 years but recently I starting getting issues. The files would show up in the Upload Center marked as "Failed to Upload. File must be checked out". They show up in Internet Explorer checked out to me but I cannot check them in. The only thing I can do is this:

1.在上载中心中，选择解决"按钮，然后选择打开进行解决".带有黄色横幅的文件:必须检出".

1.  In Upload Center select the resolve button and select open to resolve.  The files up with the yellow banner:  Must be checked Out". 

2.我将它们签出.

3.我保存它们.

4.我将其卸载，并将它们正确保存到SharePoint.

4.  I unload them and they properly save to SharePoint.

5.我必须杀死"每次打开文件以解决问题后，请点击上载中心.

5.  I have to "kill" the Upload Center after every time I open to resolve a file. 

这一切都为流程增加了宝贵的时间，因为我每次只能处理约30个文件.我相信我会使用SharePoint 2010.请指教！谢谢.

This all adds valuable time to the process as I do this is about 30 files at a time.  I use SharePoint 2010 I believe.  Please advise!  Thank you.

推荐答案

迈克，

请检查是否已在目标文档库中启用了要求签出"设置

禁用Require Check Out设置，并比较结果.

库设置>版本设置>禁用需要签出"设置.

最好的问候，

Linda Zhang

这篇关于VBA创建SharePoint文件:上传失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！