自动执行在Sharepoint上运行excel宏的过程 [英] Automating the process of running an excel macro on Sharepoint

问题描述

有没有什么方法可以自动执行从SharePoint中的excel文件运行excel宏的过程，而无需执行此操作它每天手动吗？根据我的理解，Sharepoint目前没有此功能。该宏用于通过从另一个Excel文件（复制，删除，替换）中检索数据来更新Excel电子表格的信息
。另外的建议也将不胜感激。

解决方案

你好Jon_21，

目前，excel服务和excel online不支持SharePoint 2010中excel文件中的宏。

换句话说，我们无法在SharePoint上的excel文件中运行宏。 / p>

该问题的解决方法是，您可以在Excel桌面应用程序中打开Excel文件来运行宏。

祝你好运，

Sara Fan

Is there any way to automate the process of running an excel macro from an excel file in SharePoint without having to do it manually every day? From my understanding, Sharepoint does not have this feature currently. The macro is use to update the information of the excel spreadsheet by retrieving the data from another excel file (Copy, Remove, Replace). Alternative suggestions will also be greatly appreciated.

解决方案

Hi Jon_21,

Currently, the excel service and excel online cannot support the macro in the excel file in SharePoint 2010.

In other words, we cannot run macro in the excel file on SharePoint.

The workaround for the issue, you could open the excel file in the Excel desktop application to run the macros.

Best regards,

Sara Fan

这篇关于自动执行在Sharepoint上运行excel宏的过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！