且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在不显示消息的情况下打开Excel工作簿工作簿包含指向其他数据源的链接.以编程方式?

更新时间:2022-11-03 16:28:06

尝试将其放置在工作簿中的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