I am having an issue with some VBA. When the workbook I'm working with is the only one open, Workbooks("").Close works fine. When I have another workbook open at the same time, it will close but then crash Excel. Here's my code:
I need to check if the file has been saved in a new location or not. Could the other open workbook be throwing it off, even though it isn't even being referenced in the code? Thank you for your help!
Please Login or Register to view this content.