View Single Post
Join Date: Aug 2008
Posts: 302
Reputation: aktharshaik is an unknown quantity at this point 
Solved Threads: 36
aktharshaik's Avatar
aktharshaik aktharshaik is offline Offline
Posting Whiz

Re: Dynamic setting of Headers

 
0
  #3
Dec 16th, 2008
    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
Reply With Quote