Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CODE in Access running excel will NOT set PrintTitleRows correctly
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro not running correctly | Excel Programming | |||
Data don't enter correctly in Excel 2002 running under Vista | Excel Discussion (Misc queries) | |||
addin not running correctly | Excel Programming | |||
addin not running correctly | Excel Programming | |||
Getting Access Error Messages when running Access through Excel | Excel Programming |