View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin Kevin is offline
external usenet poster
 
Posts: 504
Default using write #1 to create a batch file

I am trying to create a simple batch file to run a clarion command for
specified IP addresses and output them to a text file. When I try this
method it puts the quotes in the .bat file and the command doesn't run when
the .bat file is activated... Any suggestion?

Open "c:\Program Files\EMC\Navisphere CLI\Temp.bat" For Output As #1
Write #1, "naviseccli - h 10.60.103.18 - scope 0 getlun - capacity
kevtest.txt"
Close
Shell "C:\Program Files\EMC\Navisphere CLI\Temp.bat"


Actually, what I've been trying to do is get the output from this command to
a worksheet. Is there a simpler way to do this?

Any help is appreciated!!
Kevin Green