Workbooks("").Close Crashes Excel With Mutiple Workbooks Open

**exs120** · 09-27-2011, 12:35 PM

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:

Please Login or Register  to view this content.

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!

**exs120** · 09-27-2011, 01:38 PM

Any ideas?

**Whizbang** · 09-27-2011, 01:40 PM

This:

Please Login or Register  to view this content.

Could be this:

Please Login or Register  to view this content.

This will close the workbook without saving. I do not know if it will prevent Excel from crashing, but it does save some time.

**Mordred** · 09-27-2011, 01:42 PM

You've only waited an hour or so, sometimes problems can't be solved right away. Please show some patience and I'm sure you'll have an answer soon enough.

Thanks

**exs120** · 09-27-2011, 03:24 PM

Thank you Whizbang. I tried your code, but got the same result. Because I require users to re-save the file elsewhere, the error does not occur from the new save location. Only if they keep using the file from its original location. I have other code that asks if they want to SaveAs. If they say no, then the error would come up when closing ONLY if they have another workbook open at the same time. Very puzzling.