at the beginning of my code i have both
application.screenupdating=false and application.displayalerts=false
yet when running the code a dialog pops up that says "opening" with
the ok and cancel buttons (its a true excel message) which is
dangerous in case a user accidentally hits cancel. anyway to prevent
this? its excel 2007

basicly i loop through a folder open every file and write down a few
values.

thanks

I'm seeing that DisplayAlerts isn't captured and I'm using Office 2003. I'm
betting this is related. I was having issues earlier this week with opening
files via code that had macros in them and each file asked me if I wanted to
enable the macro. I had to change the AutomationSecurity to get that to work.

Barb Reinhardt



" wrote:

at the beginning of my code i have both
application.screenupdating=false and application.displayalerts=false
yet when running the code a dialog pops up that says "opening" with
the ok and cancel buttons (its a true excel message) which is
dangerous in case a user accidentally hits cancel. anyway to prevent
this? its excel 2007

basicly i loop through a folder open every file and write down a few
values.

thanks