PDA

View Full Version : UpdateLinksNever when Adding Template



Ray
08-17-2010, 12:45 PM
Our client has sent us an excel Template with Links to other files that they have. I am writing a VBA routine to fill out this template from data we have in our excel files.

Does anyone know of a way to shut off the prompt "The workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook?"

Application.DisplayAlerts = False
Workbooks.Add Template:="TemplateName"


Thanks for the Help!:dunno

Bob Phillips
08-17-2010, 01:39 PM
Haven't got anything to test it on here, but did you try turning off alerts?



Application.DisplayAlerts = False