Find Open Windows and Close using VBA

[Gary Cobden]

Hi

I am running an Access Database, and need to find - and close - any
open instances of MS Excel using VBA Coding

Does anybody have any sample code

I know this is possible using VB and GetWindow, but on this occasion,
I need to use VBA

Help please

Thanks

Gary

[Salad]

Gary Cobden wrote:

Hi

I am running an Access Database, and need to find - and close - any
open instances of MS Excel using VBA Coding

Does anybody have any sample code

I know this is possible using VB and GetWindow, but on this occasion,
I need to use VBA

Help please

Thanks

Gary

Goto http://www.mvps.org/access/ and check out the API calls there. I
used/modified one of the APIs to get the class/caption of the windows.
I modified it to pass back a string of the class/caption name and parsed
the string to separate the two. Next, there is an API to close an app
based on class/caption.

[Gary Cobden]

Great; the previous suggestion - check out http://www.mvps.org/access/
- was very helpful and enabled me to solve the closure of any
occurrances of Excel running with Visible = True

However, I also have an occurrance of Excel running with Visible =
False, and am having difficulty getting this to close.

Any ideas please

Thanks

Gary

[Gary Cobden]

Great; this was very helpful and enabled me to solve the closure of any
occurrances of Excel running with Visible = True

However, I also have an occurrance of Excel running with Visible =
False, and am having difficulty getting this to close.

Any ideas please

Thanks

Gary


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Salad]

Gary Cobden wrote:

Great; the previous suggestion - check out http://www.mvps.org/access/
- was very helpful and enabled me to solve the closure of any
occurrances of Excel running with Visible = True

However, I also have an occurrance of Excel running with Visible =
False, and am having difficulty getting this to close.

Any ideas please

Thanks

Gary

No I don't. I'm not sure how to set up Excel to be opened but invisible
so I'd be the wrong person to ask. You might want to post a new message
with a new subject line and see if someone answers the part of closeing
with Excel visible = False. You might also want to let the folks know
how it is opened invisibly in the new message. The reason I say repost
is that this thread is a couple of days old and people tend to look at
newer ones.