Possible? Use VBA & Copy / Clear contents of VBA Immediate Window to .txt file

[Cosmos75]

Firstly, is there a way to copy the contents of the VBA Immediate Window to a .txt file using VBA? This one doesn't sound possible to me but I thought I'd ask.

I did find this.

Secondly, is there a way to clear the contents of the VBA Immediate Window using VBA?

Just FYI, I ran this code to see how many lines I could get in the immediate window.

For i = 500 To 1 Step -1
    Debug.Print i  & " zzzzzzzzzzzzzz"  'I used more Zs' than this
Next i

I got 199 lines. Guess that is the limit.

 

[WayneRyan]

Cosmos,

This link shows how to do it from Excel:

http://www.dicks-blog.com/archives/2004/06/09/clear-the-immediate-window/

Wayne

 

[Cosmos75]

WayneRyan,

Thank you for that link!


Since it uses "keystrokes" to delete the contents of the immediate window;

[COLOR=DarkGreen]'Send CTRL+A (select all) and Delete keystokes[/COLOR]
PostMessage hChild, WM_KEYDOWN, vbKeyA, 0&
PostMessage hChild, WM_KEYDOWN, vbKeyDelete, 0&

Perhaps it is possible to copy the contents to "Notepad" or even a memo field? Though I'll have to figure out how!

When I have time I will give it a try and post back if I figure it out.