[RESOLVED] reporting in excel

[mebhas]

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

[noielen]

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

[si_the_geek]

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:

[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"

[mebhas]

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