I have a case where an individual opens multiple EXCEL sessions rather than multiple workbooks within one session for the simple reason that one session (as of Office 2007) will not let him display different spreadsheets on multiple screens.
The problem that we are trying to resolve is to how close out some workbooks that are opened without knowing the specific session used to open them. I read another case on EE where the requester tried to do similar and the conclusion was that it cannot be done. Surely that cannot be true. REF: VBA loop through each excel application submitted 7/23/2009 @ 3:58 PM