CODE for EXCEL output not executing in access - PrintTitle..

Hello,
MS Access/Excel 2003 on XP PRO.

I have a subroutine that outputs a query to an excel file and then formats
it automatically, and everything works, I get no compile errors, except for
one little failure.

when I execute the line with the > in front of it is the problem.


With obj_excel 'Excel application
'whole bunch of stuff in here

With .activesheet.PageSetup
> .PrintTitleRows = "$1:$1"
'plus other
end with

'whole bunch of stuff in here
end with

this line does not happen. It executes, moves to the next line of code, but
it does not happen. the print title rows in the output excel file are not
set. the whole point of writing code like this is to prevent manually
formatting a document so this irritates the hell out of me, since I may
output 15 documents like this in a setting.

Any idea why this line of code is not executing?
Thanks.

I find that when Automating Excel, it's usually a good idea to avoid using
..ActiveSheet, and instead explicitly refer to the sheet you mean.

Take a look at my July, 2005 "Access Answers" column in Pinnacle
Publication's "Smart Access". You can download the column (and sample
database) for free at [URL="http://www.accessmvp.com/DJSteele/SmartAccess.html"]http://www.accessmvp.com/DJSteele/SmartAccess.html[/URL] or
read it online at [URL="http://www.vb123.com/kb/200507_ds_excel.htm"]http://www.vb123.com/kb/200507_ds_excel.htm[/URL]