[RESOLVED] reporting in excel

well, my last post/question fizzled out miserably. so now i am focusing on useing excel as the reporting tool. i have a couple of questions(again).

first one, how do i change the print layout to landscape?

second one, the more important and complicated one....
file->page setup->sheet tab
there is an option for repeating certain cells as headers (rows on top & columns on left). how do i access them from vb?

bear in mind that i will be creating a new excel workbook and worksheet.

any help in this matter will be highly appreciated.... :thumb:

you can do that only in EXCEL apps... no other solution

As with anything in Excel, if you want to add the functionality to your program (which uses Excel) you can simply record a Macro of the actions, then use the code that is provided.

Admittedly you should remove most of the code in situations like this, as many other options are set too.

I recorded macros, and here is the code you want:

VB Code:

[b][i]sheet_object[/i][/b].PageSetup.Orientation = xlLandscape
 
[b][i]sheet_object[/i][/b].PageSetup.PrintTitleRows = "$1:$7"
[b][i]sheet_object[/i][/b].PageSetup.PrintTitleColumns = "$A:$C"

sorry noielen, i got all my answers from si here....
works like a charm, and more...
he just showed me the way to work with excel's page setups....
:) :thumb: