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"
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"alexhatzisavas" <alexhatzisavas[ at ]discussions.microsoft.com> wrote in message
news:CBCAD70C-9D8B-43BF-9DAE-868B4E221CC3[ at ]microsoft.com...
[Quoted Text] >
> 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
|