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

Mitsules, Mark S. (Newport News) Mark.Mitsules at ngc.com
Fri Jul 23 06:48:09 CDT 2004


I'm guessing you want to set this using automation...?
Here is an example from the help file:
ActiveSheet.PageSetup.PrintTitleRows = ActiveSheet.Rows(3).Address


Mark



-----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



More information about the AccessD mailing list