Page setting in Excel sheet

[ramesh_tankala]

hi...
i generate reports in excel sheet through vb6, How i can change the excel sheet page settings through vb6

[BSOB]

hey, whatdayaknow!
i just opened up excel, and it has visual basic as a macro editor!
anyways
messed around and found that you could say
sheet1.select
or
sheet2.select
and so on.
thats what you are looking for.
ignor my signiture