RSS Forums RSS

Dynamic setting of Headers

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Reply
Posts: 191
Reputation: dinilkarun is an unknown quantity at this point 
Solved Threads: 0
dinilkarun dinilkarun is offline Offline
Junior Poster

Dynamic setting of Headers

  #1  
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
AddThis Social Bookmark Button
Reply With Quote  
Posts: 191
Reputation: dinilkarun is an unknown quantity at this point 
Solved Threads: 0
dinilkarun dinilkarun is offline Offline
Junior Poster

Dynamic setting of Headers

  #2  
Dec 16th, 2008
PLESE help me with the above post
Last edited by dinilkarun : Dec 16th, 2008 at 8:59 am.
Reply With Quote  
Posts: 293
Reputation: aktharshaik is an unknown quantity at this point 
Solved Threads: 35
aktharshaik's Avatar
aktharshaik aktharshaik is offline Offline
Posting Whiz in Training

Re: Dynamic setting of Headers

  #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  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.



Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum
Views: 395 | Replies: 2 | Currently Viewing: 1 (0 members and 1 guests)

 

Thread Tools Display Modes
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 3:03 pm.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC