[AccessD] OT-Excel Printing Header Rows On Each Page

You want this property, I believe:
With ActiveSheet.PageSetup
        .PrintTitleRows = "$1:$1" ' <- prints the first row on every
page
        .PrintTitleColumns = ""
End With
Alternatively, you could do this manually in an XLT file, and send your
data to the xlt each time (which will "spawn" a new copy of itself each
time).

Steve




-----Original Message-----
From: paul.hartland at fsmail.net [mailto:paul.hartland at fsmail.net] 
Sent: Friday, July 23, 2004 7:40 AM
To: accessd
Subject: [AccessD] OT-Excel Printing Header Rows On Each Page


To all,
 
I have an access database which in the end opens an excel spreadsheet,
the problem being if it goes over one page I need the header to appear
on all over pages (header being row A & B).
 
Anyone any ideas how to do this, without the user having to go into Page
Setup and do it manually ?
 
Thanks in advance for any help.
 
Paul Hartland

-- 

Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/

This email has been checked for most known viruses - find out more at:
http://www.wanadoo.co.uk/help/id/7098.htm
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com