Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 4th 04, 05:17 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2003
Posts: 21
Default xp shell command using vba

Hi Everyone

I want to kill windows xp process tree for a particular
process using VBA Shell Command.

Detail Description: I am using code to produce PDF's and
due to come reason my memory is blocking and the printing
stops saying that "server threw an exception", with some
R&D I figured that Acrobat Process in Windows XP Task
Manager if exceeds 100,000K the acrobat is not able to
print Pdf's.

Can anyone used/seen any code to kill the process tree
for a particular process.(I know that i need to use the
Shell commands but never used one)

Please help me in writing the code .... thanks inadvance


  #2   Report Post  
Old February 5th 04, 09:42 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2003
Posts: 21
Default xp shell command using vba

does anyone know how to use TASKKILL shell command in vba
thanks
-----Original Message-----
Hi Everyone

I want to kill windows xp process tree for a particular
process using VBA Shell Command.

Detail Description: I am using code to produce PDF's and
due to come reason my memory is blocking and the

printing
stops saying that "server threw an exception", with some
R&D I figured that Acrobat Process in Windows XP Task
Manager if exceeds 100,000K the acrobat is not able to
print Pdf's.

Can anyone used/seen any code to kill the process tree
for a particular process.(I know that i need to use the
Shell commands but never used one)

Please help me in writing the code .... thanks inadvance

.

  #3   Report Post  
Old February 16th 04, 06:56 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2003
Posts: 1,236
Default xp shell command using vba

In the Windows XP Resource Kit (i believe there is one for XP?) there should
be a process kill command line tool. If not, there are plenty on the web.
Use the Shell command to execute.

If you need VBA to wait until the Shell has finished, then do a Google
search for ShellWait.

Oddly enough, you might be able to find an API solution to process killing
by looking at examples that are related to ShellWait.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Sudhendra" wrote in message
...
Hi Everyone

I want to kill windows xp process tree for a particular
process using VBA Shell Command.

Detail Description: I am using code to produce PDF's and
due to come reason my memory is blocking and the printing
stops saying that "server threw an exception", with some
R&D I figured that Acrobat Process in Windows XP Task
Manager if exceeds 100,000K the acrobat is not able to
print Pdf's.

Can anyone used/seen any code to kill the process tree
for a particular process.(I know that i need to use the
Shell commands but never used one)

Please help me in writing the code .... thanks inadvance





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Closing DOS window after shell command Garry Boswell Excel Programming 1 January 9th 04 11:32 PM
Application Process-Shell Command GarethG[_10_] Excel Programming 2 October 29th 03 02:35 PM
Parsing Shell Command with Parenthesis GarethG[_9_] Excel Programming 1 October 24th 03 05:53 PM
SHELL command Robin Clay[_3_] Excel Programming 3 October 17th 03 02:50 PM
How can you wait for the SHELL command to terminate ? Dave Peterson[_3_] Excel Programming 1 October 1st 03 09:10 AM


All times are GMT +1. The time now is 07:40 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017