I run most of my macros out of a file called "Personal.XLS" and I have this bit of code at the end of this particular macro which is closing personal.xls instead of the active file it is working on. It is set up on a loop and it should go to the next file in the directory but since it closes the file I run the macro from, the macro stops immediately.
It appears that it believes "ThisWorkbook.Close" is referring to the file from which the macro is initiated.
Please Login or Register to view this content.
I need the macro to close the file its working on and move to the next file in the dir.
Thanks!
Bookmarks