[eWreck]

I'm triing to put in my code that when I open a excel file the question about updating automaticl inks is answered "No" I can turn off the message with Ask to updatelinks but it assumes I want to answer yes. Anyway around this? I would simple like the links to not be updated and no question box to open, it can be confusing to users.
Thanks in advance,
Eric

[OBP]

Try turning off system messages with - DoCmd.SetWarnings False

[eWreck]

Thanks for the tip I ended up using a sendkeys cmd to answer the question i.e.
Application.Sendkeys ("n"), yes
and that worked fine.
Thanks again,
Eric