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