MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by NEED HELP on October 19, 2001 6:01 AM

I let a file open by using a macro but I still get the question if I wanna update the data cause it's related to an other file. How can I let this message disappear or let it be answered automatically with NO? Hope someone can help me with this? Thanks in advance!


Posted by Travis on October 19, 2001 6:25 AM

Try adding this line in the beginning of your macro:
Application.DisplayAlerts = False
And this line at the end:
Application.DisplayAlerts = True
That will take the message away, but I'm not sure if it will automatically answer yes or no, so test it.

Posted by NEED HELP on October 19, 2001 6:30 AM

I added your line but it still asks me what to do. Do you know some other way? Thnks.

Posted by Dan on October 19, 2001 7:25 AM

Does this work?

Workbooks.Open FileName:="C:YourFileName.xls", UpdateLinks:=3

Obviously change the File name to whatever you're opening. Let us know.