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!