Ok
I found a way.
Just wrote the bits I am interested in to a log file. I just needed to look up the file handling functions.
Open "M6start_log" For Output As #1 'open a file to write logs to
Write #1, "your text ", Your Variable
Write #1, "OldTool ", OldTool 'for instance, add as many lines of this as you like through your script
Close #1 'closes the log file
After running your macro, you should end up with a logfile in the same folder as your macro.
Dont forget to delete or comment out the logfile creation lines once you have debugged or you will eventually fill your disk up with spurious logs.
There may be a simpler way but this worked for me.
Paul