View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
John.Greenan John.Greenan is offline
external usenet poster
 
Posts: 175
Default Tough One - Return output from Dos Process without writing to

Have a look at this - I think it will help you....

http://msdn.microsoft.com/library/de...ctPropMeth.asp


--
www.alignment-systems.com


"Tom Ogilvy" wrote:

If your shelling to the app then I doubt there is a way to get anything back
except perhaps a result code which would most likely be zero.

--
Regards,
Tom Ogilvy


"Andibevan" wrote in message
...
Tom - thanks for the suggestion but I don't actually want to be able to

ping
I actually need to return output from a 3rd party app but thought my

example
would be more helpful.

As another example how would I return the information produced by the
command DIR?

"Tom Ogilvy" wrote in message
...
http://vbnet.mvps.org/code/internet/ping.htm

--
Regards,
Tom Ogilvy

"Andibevan" wrote in message
...
Hi All,

Does anyone know of an approach that could be used to return the

output
of
a
dos command without having to create a temporary file.

I am currently using the following dos command as part of a "Shell"
command:-

ping localhost temp.txt

I can only find solutions that seem to only work in .net and I need
something for good old VBA

Thanks in advance

Andi