View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Terry Pinnell[_2_] Terry Pinnell[_2_] is offline
external usenet poster
 
Posts: 50
Default Why does hyperlink fail?

Terry Pinnell wrote:

James Ravenswood wrote:

Sub Macro1()
x = Shell("cmd.exe /c C:\temp\x.txt", 1)
End Sub


Thanks James. But I'm VERY rusty on this - years since I wrote any Excel
macros. After copying that to the clipboard and opening Tools Macro
Visual Basic Editor, do I just paste that into the empty Personal.XLS that
appears? If so, then what?


Anyone able to remind me what steps to get from the above to a working
macro please?

--
Terry, East Grinstead, UK