MrExcel Publishing
Your One Stop for Excel Tips & Solutions

LET MESSAGE DISAPPEAR!!!


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!

NEED HELP


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?

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

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