Macro to close every Workbook in all Excel instances.

Hello Everyone,

I wrote the following to close all workbook except the one associated to the running macro

HTML Code: 

It works fine, but I wonder how to close workbooks in other instances.

would you know if this is possible?

thanks for your time.

-Philippe

Hi Philippe,

Excellent question, even though it took 5 months to answer. See the attached sample file (with four 'data only' files) and code that follows that has the following capabilities:
a. Count the number of open Excel Instances.
b. Identify All Open Workbooks in All Open Instances of Excel.
c. Close All Open Workbooks in All Open Instances of Excel except for the Workbook that is running the code. PERSONAL.xls or equivalent is closed in ALL Workbooks.
d. Close PERSONAL.XLS or equivalent in the current instance of Excel without asking and without saving.
e. Access the contents of an Excel File in another instance of Excel.

Lewis

Code follows in an Ordinary Code Module such as Module1:

Please Login or Register  to view this content.

Thanks LJMetzger. Now I need to debug through it step by step to understand it.

Hi

I know this thread is old, but I'm hoping someone might be able to help.

I'm getting a compile error, type mismatch at:

Call IIDFromString(StrPtr(IID_IDispatch), iID)

I'm running Office 365 Pro Plus OS 64bit, Excel 64bit. I've adapated the Private Declare statements at the beginning to be compatible with 64bit, ie "Private Declare PtrSafe Function" etc

Any help greatly appreciated.

Cheers

pvr928

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

----------------------

It is very difficult to debug a problem like yours out of context. If you still need a reply, start a new thread, that contains all the code (including API routine declarations) that will clearly demonstrate your problem.

Lewis