nah i did make sure to save as .xlsm (the messagebox worked fine). if it works fine for you and not for me maybe you're right about the add-in. or settings issue. anyway sounds like something i need to figure out on my side unless any future releases after v10.1.20 could've addressed something like ...

i tried your suggestion w/only those two lines, and i still get the same results unfortunately. fine in windows explorer, fine using ms calling excel 2003, does not quit using ms calling excel 2007. i tried checking "trust access to vba object model" and a couple other things in excel but nothing se...

okay, my problem doesn't appear to be related to which version of Excel created the file. i replicated the file except in 2007, and i get the same results. using macro scheduler, if i open it using excel 2003 it opens and closes fine. if i open from windows explorer it also opens and closes fine. ho...

is it possible this is because the original file was created in Excel 2003? i will do some testing and reply back, thanks

hello, we're in the process of upgrading to office 2007 at my work. i'm having an issue with excel, unfortunately...i've been searching for a while and still haven't found answer, hope someone can help! in my excel file, i have a function that is called automatically when it is opened. everything wo...

The macro has been running great for the past week, and the error message finally sent out the one time it should have. Thanks again!

Ah, I guess I did not test for that case...only when the file was there and updated, and when the file was there but not updated. Guess it does disappear for a short time while it's being re-generated. Thanks a lot for the insight...I will make those changes and see if that takes care of the problem!

I have a script that loops for a certain amount of time and looks to see if a file has been updated. Once updated, it should open a self-executing excel file. If it times out, then it should open a self-executing excel error file. What's been happening is that usually the checked file is updated bef...