如何在不显示消息的情况下打开Excel工作簿工作簿包含指向其他数据源的链接.以编程方式? [英] How to open Excel-workbooks without the message The workbook contains links to other data sources. programmatically?

问题描述

我想以编程方式打开一本或多本Excel工作簿.当我打开工作簿时，您会遇到一个问题:该工作簿包含指向其他数据源的链接.而且，我不想按"不更新".

如何离开此消息框?因此，该功能将不会再中断.不需要更新.

解决方案

尝试将其放置在工作簿中的Open事件处理程序中:

Application.AskToUpdateLinks = False

I want to open 1 or more Excel-workbooks programmatically. And when I open the workbook, you get a question: The workbook contains links to other data sources. And I don't want press "Don't update"

How can you leave this messagebox? So the functionality will not interrupted anymore. Updating is not needed.

解决方案

try placing in the workbook Open event handler:

Application.AskToUpdateLinks = False

这篇关于如何在不显示消息的情况下打开Excel工作簿工作簿包含指向其他数据源的链接.以编程方式?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！