jmhla at earthlink.net
jmhla at earthlink.net
Fri Jul 23 06:44:41 CDT 2004
Paul, I do not know the code but you need to open the Excel object model and access the page setup options. In Excel turn on the macro recorder and set the options manually. Look at the generated code. -----Original Message----- From: paul.hartland at fsmail.net Sent: Jul 23, 2004 4:40 AM To: accessd <accessd at databaseadvisors.com> 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