View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Heiko Heiko is offline
external usenet poster
 
Posts: 16
Default How to detect Acrobat Distiller open

Hello Bill

<Distiller will work.

Heiko
:-)
"Bill Li" wrote:

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