View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel[_23_] joel[_23_] is offline
external usenet poster
 
Posts: 1
Default SendKeys not sending to Cmd.exe


CMD.EXE is a DOS window and will not work with send key. You have few
choices


1) Put your commands into a ".BAT" file and execute the bat file from
the shell command

shell("CMD.EXE c:\temp\mybat.bat")


2) Open a explorer window

hndl = Shell("c:\windows\explorer.exe")

3) Open the application directly using the shell command

hndl = shell("C:\Program Files\Microsoft Office\OFFICE11\excel.exe")


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=145546