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!
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!