Hello,
MS Access/Excel 2003 on XP PRO.

I have code that exports a query, opens it in excel, formats and closes it.

A part of this code assigns row one as the "Header" Row so that it prints on
every page.
With .ActiveSheet.PageSetup
.PrintTitleRows = "$1:$1"
.PrintTitleColumns = ""
End With


It runs perfect, returns NO error message, passes everytime, but then I go
to the excel file and there is NO header Row? What the ^&%$ is happening?

Thanks.

--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!

I assume the printout looks fine
Does the code save the workbook after copying the headers?

"BlueWolverine" wrote:

> Hello,
> MS Access/Excel 2003 on XP PRO.
>
> I have code that exports a query, opens it in excel, formats and closes it.
>
> A part of this code assigns row one as the "Header" Row so that it prints on
> every page.
> With .ActiveSheet.PageSetup
> .PrintTitleRows = "$1:$1"
> .PrintTitleColumns = ""
> End With
>
>
> It runs perfect, returns NO error message, passes everytime, but then I go
> to the excel file and there is NO header Row? What the ^&%$ is happening?
>
> Thanks.
>
> --
> BlueWolverine
> MSE - Mech. Eng.
> Go BLUE!

Yes it does. the last thing I do before I close the workbook and the excel
object is save the workbook. (otherwise, as I found out in an especially
frustrating evening, the formatting doesn't take.)

What does that do?

--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!


"Patrick Molloy" wrote:

>
> I assume the printout looks fine
> Does the code save the workbook after copying the headers?
>
> "BlueWolverine" wrote:
>
> > Hello,
> > MS Access/Excel 2003 on XP PRO.
> >
> > I have code that exports a query, opens it in excel, formats and closes it.
> >
> > A part of this code assigns row one as the "Header" Row so that it prints on
> > every page.
> > With .ActiveSheet.PageSetup
> > .PrintTitleRows = "$1:$1"
> > .PrintTitleColumns = ""
> > End With
> >
> >
> > It runs perfect, returns NO error message, passes everytime, but then I go
> > to the excel file and there is NO header Row? What the ^&%$ is happening?
> >
> > Thanks.
> >
> > --
> > BlueWolverine
> > MSE - Mech. Eng.
> > Go BLUE!