Hi Terry
Now go to ToolsMacroMacros and select Personal.XLS!Macro1
if you didn't change the name of the macro then press Run.
Also you could create a button to execute the macro.
HTH
Cimjet
"Terry Pinnell" wrote in message
...
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