View Single Post
  #1   Report Post  
Old January 28th 04, 10:52 PM posted to microsoft.public.excel.programming
Ryan Waltz Ryan Waltz is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2004
Posts: 1
Default Writing Command Shell (stdOut) to Excel Cells

Hi,

I'm trying to write a VBA macro to write output from a command shell
command back to cells in the spreadsheet. Specifically, I'm grabbing
IP addresses in one column in Excel, running a reverse ping against
each IP address and writing the hostname result in a separate column
in Excel. I've got all of it finished except for writing the output of
the ping command into the separate Excel column.

Any would be much appreciated!

Thanks