PDA

View Full Version : Disabling the "Do you want to update..." message



ttocs
10-30-2008, 04:37 AM
Hey guys,

I have a script I run each morning that kicks off a report. Took me a while to do, but it's finally finished. Now, I'm just cleaning up some of the spots that work, but not efficiently. One such spot, is when I open up this one file. The excel file always asks me if I want to update the contents. The answer is always no, and after I click it, it goes about it's job. I thought that putting the DisplayAlerts = False script would do the trick, but I'm still seeing it. Anyone have the code to disable any popups when I open another workbook? All I can find on google is the displayalerts one.

Thanks!

Bob Phillips
10-30-2008, 04:42 AM
Has it got links? If so, set the Updatelinks property to 0 in the Open method.