check out http://www.greggriffiths.org/webdev/both/excel/ and then add in 
some VBA to the mix and you should have a solution.

At 23:39 31/08/02 +0000, you wrote:
>My problem seems easy but I think I tried every trick in the book.
>
>I'm creating a list of item from database in a asp page that generates
>from that data a excel sheet. I would like to have a pagebreak after every
>item so only one item would show in one page when printing.
>
>Thing is that I can generate excel w/o any problems but when I try to
>insert pagebreaks do it by using asp I always get and error message.
>
>So if some1 could tell me the correct method and syntax for inserting
>pagebreaks to excel sheet by asp I would be very pleased.
>
>K Hiitola
>
>---
>
>Improve your web design skills with these new books from Glasshaus.
>
>Usable Web Menus
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
>r-20
>Constructing Accessible Web Sites
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
>r-20
>Practical JavaScript for the Usable Web
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
>r-20