EXTRACTING TABLES FROM A SPOOL

[molugbode]

I have written a series of programmes which runs a series of OLS regression models and transfers the output to a spool. However when I want to copy the tables to excel, I found that I could only copy and paste one table at a time. I have a lot of tables in the spool and was hoping if anyone knew of how I could copy all tables within the spool to an excel sheet at once. Also if this is not possible, is there anyother way of tackling this .


Many thanks in advance.

[EViews Gareth]

Search is your friend

[molugbode]

Many thanks for your suggestions.

I have tried both options:

output(r) c:\myrtffile.rtf 'redirect printing to a rtf file
' or
output(t) c:\mytextfile.txt 'redirect printing to a text file

print myspool

I keep getting the message" unable to open file in "print myspool" .
This is an abridged version of the programme I have used.

equation eq1.LS(N) AERO C INDVAR
equation eq2.LS(N) AUTO C INDVAR
equation eq3.LS(N) BEVERAGE C INDVAR

spool myspool

myspool.append eq1
myspool.append eq2
myspool.append eq3

Probably gone wrong at some point. Can you kindly proffer suggestions ?

[molugbode]

Many thanks. Sorted it out now.