Manipulate contents of Immediate window

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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"
 
Back
Top