Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a way to close an application called "PDFCreator" if it happens to
be still active? The problem that I have in running PDFCreator is that it doesn't always shut down before the next instance of running, and won't create the PDF. I'm using code from Ken Puls website, and have coded in both of his suggestions to shut it down and waittime, but it still creates problems. I have to open the task manager and close PDFCreator manually, which is a pain in the neck in automated code. What I'd like to do is get VB to see if PDFCreator is running, and if it is then shut it down, before running it again. Can VB access the task manager? Is there anything that could be done with the following code (from VB help)? Regards, Brett. Application.Interactive = False Application.DisplayAlerts = False channelNumber = Application.DDEInitiate( _ app:="WinWord", _ topic:="C:\WINWORD\FORMLETR.DOC") Application.DDEExecute channelNumber, "[FILEPRINT]" Application.DDETerminate channelNumber Application.DisplayAlerts = True Application.Interactive = True |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VB/VBA to read Task Manager | Excel Programming | |||
VB/VBA to read Task Manager | Excel Programming | |||
VB/VBA to read Task Manager | Excel Programming | |||
dialog box for active cell task to speed repeditive task | Excel Programming | |||
Excel Remains Active in Windows Task Manager | Excel Programming |