更新时间: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