Results 1 to 3 of 3

Thread: Insert picture in Excel using VBA

Threaded View

  1. #1

    Thread Starter
    Lively Member yanty's Avatar
    Join Date
    Nov 2005
    Location
    Singapore
    Posts
    83

    Resolved Insert picture in Excel using VBA

    Hi all.

    I can insert picture to the header of my excel sheet using the below codes

    VB Code:
    1. Dim oSW As Excel.Worksheet
    2. 'Add picture at left header
    3.     Set oSW = Worksheets(1)
    4.     With oSW.PageSetup.LeftHeaderPicture
    5.     .FileName = (App.Path & "/Pic.jpg")
    6.     .Height = 50
    7.     End with

    But the problem is my data on the excel sheet will cover part of the picture in the header. (See attached image)Why is this so that data can be mixed with header of the worksheet? any solutions?
    Attached Images Attached Images  
    Last edited by yanty; Feb 21st, 2006 at 04:24 AM.
    I think I'm starting to like programming, but I'm still far from good

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width