From Immediate window to Text file - create a log file

[Dan]

Hi,
I have an application that different functions are publishing thing on the
Immediate window.
I would like to have all the output of the Immediate window saved on a text
file - so creating some king of log file - is it doable?

Many thanks.
Raphael

 

[Tim Williams]

If you have access to the code then just create a sub to wrap your
"debug.print" calls. It could also (depending on something like a global
flag) output to a text file.

Google for creating a text file from Excel VBA.

Tim