CODE FOR EXCEL print col Rows NOT executing at all

B

BlueWolverine

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.
 
B

BlueWolverine

Here's what I tried

with obj_excel
set obj_sheet=.activesheet
-------------------------------
with obj_sheet.pagesetup
.PrintTitleRows = "$1:$1"
.PrintTitleColumns = ""
End With
--------------------------------
end with

THIS DID NOT WORK!!!! HELP!

Thank you for the idea though.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CODE in Access running excel will NOT set PrintTitleRows correctly 2
CODE for EXCEL output not executing in access - PrintTitleRows 4
export excel data to access table using ADO 0
Insert Row 2
I have exported to Excel but the file is copied twice? 7
Trying to hide all rows where no data is in columns AQ-AV 2
Macros the same but not acting the same 0
VBA Calculation for filtered data 4

Top