close another application vba

[Ramses28]

I have the following code to open an external app:

ActiveWorkbook.FollowHyperlink Address:=("\\PublicI\\3.QGIS\MAPA.qgs"), NewWindow:=True

What code can i use to close it?

Thanks

 

[cerfani]

try ActiveWorkbook.Close

 

[Ramses28]

Doesn't work.
It is not a Workbook. Its an external application.
Thanks

 

[cerfani]

oh my bad, i read the question too quickly... look at this other thread, the answer is here... you need to use windows functions by importing first... look at this post...

https://www.mrexcel.com/forum/excel...cations-vba-code-post2313752.html#post2313752

 

[Ramses28]

I have tried the Kill Process method but couldn't find the way to close it.

 

[cerfani]

the only way i know how is to use windows api but i dont see vba code for it, you can look up the examples in c++ and import the proper functions, setup the proper structures in vba and try it that way... might be a little tough to convert but im pretty sure your only option is to use windows api...

https://stackoverflow.com/questions...ce=google_rich_qa&utm_campaign=google_rich_qa
https://support.microsoft.com/en-us/help/178893/how-to-terminate-an-application-cleanly-in-win32 (this site mentions, in win32, there is no guarantee to close a process cleanly but rather you can take steps to help it close cleanly)

maybe there is vba sample code but i didnt see after a quick google search

 

[Jaafar Tribak]

If you know the application class name or the exact title name that is displayed in the application main caption bar then you should, hopefully, be able use aome API calls to get its hwnd and then close it.

 

[Ramses28]

How does the API work? Never worked with it. Thanks

 

[Jaafar Tribak]

How does the API work? Never worked with it. Thanks

What's the exact text displayed on the program main caption ?

 

[Ramses28]

The exact text displayed is "QGIS 2.18.18 - MAPA"