Hi Barb

I always use the numbers (never test it with False)

Excel 2003 and 2007 Help
1 User specifies how links will be updated
2 Never update links for this workbook on opening
3 Always update links for this workbook on opening

If you use 2 or 3 both will update the links so the help is not correct

Excel 2000 Help
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

I think 3 and 0 are the best options if you want to update or not and is
working in all Excel versions as far as I know.

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Barb Reinhardt" wrote in message
...
Ron,

I've used UpdateLinks:=False.

I'm guessing False equates to 0. Is there some reason I should use 0
instead of False?

Barb Reinhardt



"Ron de Bruin" wrote:

Correct, it is wrong in the help of a lot of Exel versions, i believe it is correct
in the good old Excel 2000

If you have links in your workbook this (UpdateLinks:=0) will avoid the message
do you want to update the links or not "0 Doesn't update any references"
Use 3 instead of 0 if you want to update the links.


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ryguy7272" wrote in message ...
If you have links in your workbook this (UpdateLinks:=0) will avoid the message

...from a Ron de Bruin post...


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"ker_01" wrote:

'Open workbook
Application.DisplayAlerts = False
Set twb = Workbooks.Open(FileName:=MyFullFilePath, ReadOnly:=True)
Application.DisplayAlerts = True

When my target workbook contains links, I still get a warning pop-up asking
if links should be updated, even with displayalerts = False.

So I changed the open statement to:
Application.DisplayAlerts = False
Set twb = Workbooks.Open(FileName:=MyFullFilePath, UpdateLinks:=False,
ReadOnly:=True)
Application.DisplayAlerts = True

It bypasses that initial warning, but then pops up the filesearch
wizard/userform with the title bar "Update Values: HsTbar.xla" which I'm
guessing is an add-in used by the person providing me the data sheet. This is
not what I'd expect, since I set UpdateLinks = False

I'm just trying to copy the data out of one sheet (format and values, not
formulas or links) but I need to do so in a way that is fully automated (no
user prompts) so that my code can run overnight.

How can I completely bypass the links alerts and just open the file via VBA?

Thank you,
Keith
.