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