DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Visual Basic 4 / 5 / 6 RSS

Dynamic setting of Headers

•

Join Date: Feb 2008

Posts: 198

Reputation: dinilkarun is an unknown quantity at this point

Solved Threads: 0

dinilkarun dinilkarun is offline

Offline

Junior Poster

Dynamic setting of Headers

Dec 5th, 2008

hi,

Through VB i want to set the first 3 rows of my excel sheet as HEADER so that those 3 rows will be common header for all the pages when i print them.

Regards,
Dinil

•

Join Date: Feb 2008

Posts: 198

Reputation: dinilkarun is an unknown quantity at this point

Solved Threads: 0

dinilkarun dinilkarun is offline

Offline

Junior Poster

Dynamic setting of Headers

Dec 16th, 2008

PLESE help me with the above post

Last edited by dinilkarun; Dec 16th, 2008 at 9:59 am.

•

Join Date: Aug 2008

Posts: 302

Reputation: aktharshaik is an unknown quantity at this point

Solved Threads: 36

aktharshaik aktharshaik is offline

Offline

Posting Whiz

Re: Dynamic setting of Headers

Dec 16th, 2008

Help with Code Tags

(Toggle Plain Text)

    Dim Exmp As New Excel.Application
    Dim WB As Excel.Workbook
    Dim Sh As Excel.Worksheet

    Set WB = Exmp.Workbooks.Open("C:\abc.xls")
    Set Sh = WB.ActiveSheet
    Sh.PageSetup.PrintHeadings = True
    Sh.PageSetup.PrintTitleRows = "$1:$3"
    WB.Save
    Exmp.Visible = True
    Set Exmp = Nothing

Regards
Shaik Akthar