View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Robin Hammond[_2_] Robin Hammond[_2_] is offline
external usenet poster
 
Posts: 575
Default Linked table message in VBA

Tom,

try

Workbooks.Open Filename:= "FullPath", UpdateLinks:=0

Robin Hammond
www.enhanceddatasystems.com

"Tom" wrote in message
...
When I open a spreadsheet with linked data I get a message box that asks

if
I want to update the data.
How do I disable this message in VBA. I have as series of worksheets

that
I am opening and I would like to stop those message boxes from opening.
Thanks
Tom