View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default From Immediate window to Text file - create a log file

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

"Dan" wrote in message
...
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