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

Thanks everyone, never even thought of looking in the help today.....can tell it's Friday.....





Message date : Jul 23 2004, 12:52 PM
>From : "Mitsules, Mark S. (Newport News)" 
To : "'Access Developers discussion and problem solving'" 
Copy to : 
Subject : RE: [AccessD] OT-Excel Printing Header Rows On Each Page
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
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 

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