About Us

Heiko

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

Bill Li

Hello Heiko,

Thanks a lot! It works.

Best Regards

Bill

-----Original Message-----
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

.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Detect open-state of xls from outside Excel	Waterloo	Excel Discussion (Misc queries)	2	May 6th 09 10:01 AM
how to re install Adobe Acrobat in Excel? The adobe Acrobat work.	Execl error	Excel Discussion (Misc queries)	1	March 17th 05 02:29 AM
How do I auto-save multipage report printing to Acrobat Distiller	sbutler96	Excel Discussion (Misc queries)	1	March 9th 05 04:15 AM
Acrobat	Vulcan	Setting up and Configuration of Excel	0	December 8th 04 11:09 PM
Detect if file is open	Chad[_6_]	Excel Programming	4	July 9th 03 05:05 AM

Menu

About Us