>I have a spreasheet that is linked to another file. In the application I am writing I do not need the other file yet excel upon opening prompts me with a messagebox that asks if I want to update the wookbook. How do I throw a keystroke to Excel to simulate clicking the no button
Try passing something other than the default value for the second parameter to Workbooks.Open. That parameter is documented as:
UpdateLinks Optional Variant. Specifies the way links in the file are updated. If this argument is omitted, the user is prompted to specify how links will be updated. Otherwise, this argument is one of the values listed in the following table.
Value Meaning
0 Doesn't update any references
1 Updates external references but not remote references
2 Updates remote references but not external references
3 Updates both remote and external references
If Microsoft Excel is opening a file in the WKS, WK1, or WK3 format and the UpdateLinks argument is 2, Microsoft Excel generates charts from the graphs attached to the file. If the argument is 0, no charts are created.
Tamar
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only