Manipulate contents of Immediate window

[Guest]

Hi all.

I'm wondering, is there some way to manipulate ALL the contents of the
Immediate window?

I've got some code that processes a sizeable table and prints text into the
Immediate window that indicates how the execution of the code is going.

Would there be some funky way to grab ALL the text that's printed in the
Immediate window?
If i go in there after the execution is completed, the window only holds the
last 300 lines of script or so.

Thanks,
Alex

 

[Allen Browne]

At the start of your routine:
Open "C:\MyFile.txt" For Output As #1

At the end of your routine:
Close #1

In between, replace each:
Debug.Print "xxxx"
with:
Print #1, "xxxx"