I have a XLSM in a folder, and part of a macro is to create a new folder, then SaveAs in to the new folder, then delete the original folder (with the original XLSM in it).

I'd like to put an IF statement in the macro where it looks to see if the original folder is currently open. If it is, close it before the SaveAs, and if not then do nothing.



The only thing I can find using Google pertains to Internet Explorer windows, nothing about folder windows.

Please help?