错误1004：Excel宏无法间歇性地打开工作簿 [英] Error 1004: Excel Macro fails to open workbook intermittently

问题描述

我在电子表格中使用Excel宏来从主电子表格中检索数据。我们在同一个SharePoint 365文件夹中都有两个电子表格。当我访问该文件并更新电子表格时，宏可以间歇性地连接到主
文件并进行更新。使用的代码如下：

I am using Excel macros in a spreadsheet to retrieve data from master spreadsheet. We have both the spreadsheets on the same SharePoint 365 folder. when I access the file and update the spreadsheet, the macro is able to intermittently connect to the master file and update. The code being used is below:

我在Workbooks.open行上收到错误。此错误随机发生：

I get the error on Workbooks.open line. This error occurs randomly as:

运行时错误'1004'：

Run-time Error '1004':

方法'打开'对象'工作簿'失败

Method 'Open' of object 'Workbooks' failed

推荐答案

你好VJ-A，



根据你的描述，我建议你检查这个文件，请参考以下链接：
$


http://stackoverflow.com/questions/19505513/open-an-excel-file-from-sharepoint-site



免责声明：此回复包含对第三方万维网站点的引用。 Microsoft提供此信息是为了方便您。 Microsoft不控制这些网站，也未测试在这些网站上找到的任何软件或信息;因此，Microsoft不能就其中发现的任何软件或信息的质量，安全性或适用性做出任何陈述。使用互联网上的任何软件都存在固有的危险，微软提醒您在从互联网上检索任何软件之前确保您完全了解风险的
。



感谢您的理解。

Hi VJ-A,

According to your description, I suggest that you could check this file, refer to this link below:

http://stackoverflow.com/questions/19505513/open-an-excel-file-from-sharepoint-site

Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

Thanks for your understanding.

这篇关于错误1004：Excel宏无法间歇性地打开工作簿的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！