Send Immediate window contents to text file

[Dixie]

Is there any code I can use to send the contents of the immediate window to
a text file?

dixie

[pietlinden]

Dixie wrote:

Is there any code I can use to send the contents of the immediate window to
a text file?

dixie

Copy and Paste it? Not enough info to answer the question. How are
you writing to the immediate window? using Debug.print? If so, read
up on Print #. Then you can just change all the Debug.Print to Print
#<filenumber>.

[Dixie]

Thankyou piet, just what I needed.

dixie

<pi********@hotmail.comwrote in message
news:11**********************@75g2000cwc.googlegro ups.com...

>
Dixie wrote:

>Is there any code I can use to send the contents of the immediate window
to
a text file?

dixie

Copy and Paste it? Not enough info to answer the question. How are
you writing to the immediate window? using Debug.print? If so, read
up on Print #. Then you can just change all the Debug.Print to Print
#<filenumber>.

[Dixie]

Sorry, I should have said that yes, it was a debug.print and I read up on
the Print # statement and its example, then modified my code to suit. It
worked straight away, which is always good.

Dixie

"Dixie" <di***@dogmail.comwrote in message
news:12*************@corp.supernews.com...

Thankyou piet, just what I needed.

dixie

<pi********@hotmail.comwrote in message
news:11**********************@75g2000cwc.googlegro ups.com...

>>
Dixie wrote:

>>Is there any code I can use to send the contents of the immediate window
to
a text file?

dixie

Copy and Paste it? Not enough info to answer the question. How are
you writing to the immediate window? using Debug.print? If so, read
up on Print #. Then you can just change all the Debug.Print to Print
#<filenumber>.