From Immediate window to Text file - create a log file

D

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
 
T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HELP: How to restore Immediate Window to original state? 15
Novice question: I cannot get the immediate window to work 2
Protocol in Immediate window? 3
How to force the immediate window in the VBE to clear 4
The worksheet calculates too often 6
Origin of Immediate Window messages 4
Immediate window gives different results to a UDF 3
Immediate Window has a size limitation? 5

Top