VBA Workbooks.open方法以只读方式打开文件 [英] VBA Workbooks.open method opens file in Read only

问题描述

大家好，

我正在使用 下面的方法从SharePoint打开文件但它只读打开。我想在编辑模式下打开它。 我已将sharepoint文档库映射为网络驱动器文件夹。

I am using  below method to open the file from SharePoint but it opens read only. I want to open it in edit mode.  I have mapped sharepoint documents library as network drive folder.

我可以在编辑模式下手动打开文件。我还尝试通过删除Readonly：=以下代码中的假行但仍然只读文件打开。

I can open the file manually in edit mode. I have also tried by removing Readonly:=false lines in below code but still file opens read only.

Pthname = "//xxx.sharepoint.com/sites/Communities/xyzSetting-/Shared Documents/UUU"
Filename = "Test.xlsm""
Workbooks.Open Filename:=Pthname & "/" & Filename, ReadOnly:=false

谢谢，

Zav

推荐答案

Hi,

你使用Office2016吗？它是否显示"我们从服务器以只读方式打开此工作簿" ？

Do you use Office2016? Does it show "We opened this workbook read-only from the server" ?

请访问
Excel 2016以只读方式打开SharePoint工作簿

尝试将代码编辑为：

Workbooks.Open FileName：= Pthname& " /" &安培; FileName，ReadOnly：= False，Notify：= False

Workbooks.Open FileName:=Pthname & "/" & FileName, ReadOnly:=False, Notify:=False

这篇关于VBA Workbooks.open方法以只读方式打开文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！