Close all other applications

[aman1234]

Hi All

I want to write vba code that is invoked on opening a spreadsheet that will firstly warn the user that if they continue(vb yes/No) then all open MS office applications will be automatically closed (Like MS Outlook,MSWOrd, Power point etc) .

So the vba code should close all Microsoft applications except the current spreadsheet.

Any help would be much appreciated.

Thanks

[mohd9876]

Try this for word, outlook and power point:

Please Login or Register  to view this content.

[JBeaucaire]

A little tighter implementation, just list the apps you want to close in the array at the top:

Please Login or Register  to view this content.

[aman1234]

Hi guys

Thanks a lot for your help. It worked but just one question "Is it possible if other excel applications are opened then close them too apart from this current workbook"

Please see attached.

Thanks

[JBeaucaire]

I would suggest you correct your system settings so that all Excel workbooks are opened in the same instance of Excel. Allowing the system to start multiple instances of the same App usually gives me more grief than benefit.

Then you won't need to hunt for other "instances" of Excel, they won't exist.

[Leith Ross]

Hello aman1234,

There is no need to correct anything. This can be easily accomplished using the Windows API. Copy this code into a separate module in your workbook's VBA project. You can call the macro manually, using ALT+F8, or call from inside your code. This closes only Office applications other than the one running the macro.

Please Login or Register  to view this content.

[aman1234]

Hi Leith

I have written the following code but it doesn't do anything:

Please Login or Register  to view this content.

I hope you can help me out in this.

Thanks

[Leith Ross]

Hello aman1234,

If nothing happened then you have no Office applications running besides Excel. This macro will not close other workbooks that are open in the same instance of Excel. Perhaps I misunderstood your needs. If you need to close all other workbooks, except the one running the macro, in the same instance of excel then you will need the macro below,

Please Login or Register  to view this content.

[aman1234]

Hi guys

The code was working but suppose if already opened applications are not saved yet then this code asks everytime "do you want to save the application first before closing" . I want it to automatically save all the opened applications before closing.

Can anyone please help me how to do it?

Thanks

[snb]

To me it seems your project is heading for 'the most irritation provoking software' award.

[aman1234]

Well snb. I am not hear to get any award . If you can't help to solve my problem then please don't comment atleast.

[JBeaucaire]

Add this to autosave changes:

Please Login or Register  to view this content.

SNB's comment was meant to warn you again that others using your macros might not appreciate these decisions.

[snb]

@JB

How very correct indeed !

[aman1234]

Hi
The following code will only save the workbooks but I want to save all the applications which are currently opened automatically before closing them e.g access, word , powerpoint applications.

Please Login or Register  to view this content.

Thanks

[snb]

@Amman

Since 24-02-2009 you started 137 threads, of which 12 you marked as 'solved'. Are those 125 threads still bothering you ?
If not, please mark them as 'solved', or send a moderator a request to do so.

[aman1234]

You have time to view my thread again and again but no knowledge to solve my problem.
Marking other threads solved is not the answer of my question in this thread.

[Colin Legg]

@aman

Why does your Excel workbook need to close every other Office application?

[snb]

Proper forum behaviour will be highly appreciated ! (see the forum rules)
Especially in return of so much outstanding free help.

[aman1234]

Hi Colin

This is what my boss asked me to do. So I am able to close all the office a[pplications but not sure how to save them automatically before closing them.

Thanks

[Colin Legg]

Hi Aman,

I feel your pain.

The reason I asked is I couldn't think of a genuinely good reason to require that all other Office applications be closed down when a workbook is opened. Perhaps you should ask your boss to clarify why s/he asked for this, because at the moment it sounds like a very questionable design decision. Nobody (except your boss?) wants a workbook to close down all of their open Office apps.

Once we understand the reason(s) why, we may be able to think of a better solution for you.

My 2 cents...