Thanks, I have edited the Ask To Update feature and we'll see what happens. If that does not take care of it, I will try the dual macros option.

Thanks again!

New to creating macros and have found this resource to be most helpful! I have created the macro below (with some help) and it works....about 95% of the time. Unfortunately, this is not reliable enough. The macro is supposed to check to see if a particular spreadsheet or a particular database is ope...

I was soooo close! Thanks for responding, it works like a champ.

I am trying to write and If statement to see if a file is open (if it is, I need to end the macro, if it is not, I need to proceed to the next instruction). I have found IfFileExists but this is not what I need. I found this article http://support.microsoft.com/default.aspx?scid=kb;EN-US;q138621 in ...

I will have to try the script idea...but I am sure IT would rather just put my macro on one of their servers rather than keep my system in a state of "unlock" all the time. Regarding the macro itself, it will need to run every 15 minutes for the next couple of months, so changing my time out to 20 m...

I am new to scripting and I have put together a solution that is probably not very "elegant" but it works (sort of). My main problem seems to center around using Application.Quit. I have to open and update a number of excel files with this one macro and then save 2 as tab delimited text files. At th...