ExcelBanter - How to detect Acrobat Distiller open

Hi Chip,

Great! It works.

Thanks a lot!

Best Regards

Bill

-----Original Message-----
Bill,

Believe it or not, the class name is "Distiller".

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Bill Li" wrote in message
...
Hello All,

I am try to build the code to print out postscript file
and then convert it via Acrobat Distiller. However, I
couldn't detect whether Acrobat Distiller open or
close. I
try to user following code to detect.

Declare Function Findwindow Lib "user32"
Alias "FindWindowA" _
(ByVal lpClassName As String, ByVal LpWindowName As
Long)
As Long

Sub Detect_A()
Dim hwn As Long
hwn = Findwindow("XLMAIN", 0)
If hwn = 0 Then
MsgBox "Excel close"
Else
MsgBox "Excel open"
End If

End Sub

It works for Excel, Word, etc. However, I don't know the
class name for Acrobat Distiller and couldn't check.
Does
anypeople have the idea to check the Acrobat Distiller's
class name. (Sorry, I don't have spy.exe in my pc).

Thanks in advance!

Best Regards

Bill

.