Robert
robert at servicexp.com
Fri Jan 25 18:26:47 CST 2008
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 After you located the open document could you do something like If objword.Application.visible = True Then end if WBR Robert jwcolby wrote: > I am using a mail merge system that occasionally leaves Word open but > hidden. The next time the mail merge tries to run it can't since word is > open and holding a file open that the mail merge function is trying to > create. Thus I need to get a handle on any open word instance, and > hopefully see if it is hidden. If so assume it is mine and close it. Is > there any way to do such a thing in VBA code? > > Thanks, > > John W. Colby > Colby Consulting > www.ColbyConsulting.com > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHmn5G72dSYCwH8FQRAk50AJ9k10LUFduKS0pauIkcBL6aQZaYiQCfSJmt ALLwoojIx5PT/VOcfpwIUTA= =a8GV -----END PGP SIGNATURE-----