| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linked table message in VBA
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Linked table message in VBA
Tom wrote
How do I disable this message in VBA. If you always want this to happen, consider unchecking 'Ask to update automatic links' in Tools|Options|Edit -- David |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Linked table message in VBA
Hmmmm....
I never thought to set that on the spreadsheet itself....I figured that I would need to do it the most difficult way. I needed to write it in code. It worked! I just set the option on the worksheet that was open and it took care of the box. Thanks David! Tom "David" wrote in message ... Tom wrote How do I disable this message in VBA. If you always want this to happen, consider unchecking 'Ask to update automatic links' in Tools|Options|Edit -- David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error message #N/A appears in linked cells | Links and Linking in Excel | |||
| Error message help with linked worbook | Excel Discussion (Misc queries) | |||
| DV message linked | Excel Discussion (Misc queries) | |||
| Formula too long error message to linked spreadsheet | Links and Linking in Excel | |||
| Insert rows in linked table that are added to secondary table | Excel Discussion (Misc queries) | |||
Linear Mode
