Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Australia
    Posts
    245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adding an Image File (Excell All)

    I have created a small TIF image that corresponds to a 'certification' in an online certificate users create.

    I want to have the user click on a toolbar button to have the certification image placed in a selected cell. (If necessary it could be programatically added to the same cell each time a certificate is created.)

    My problem is how to make it 'stick' to a particular cell.

    Any suggestions or solutions please?

    Leigh

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Adding an Image File (Excell All)

    Leigh

    You can do something like:

    ActiveSheet.OLEObjects.Add(FileName:= " String containing the path and name of object " , Link:=False, DisplayAsIcon:=False)
    to add the certificate. Now how to position it, well this is hard because I think it depends on the screen resolution but you can check the

    IncrementLeft, and IncrementTop methods of the ShapeRange.

    Hope this helps

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Australia
    Posts
    245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding an Image File (Excel All)

    Hi Wassim

    Thanks for your reply. I will try it out later today.

    I might give the users a toolbar button to insert the image then get them to click and drag the object to its final destination to solve the problem of screen resolution. Thanks again.

    Leigh

  4. #4
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Adding an Image File (Excel All)

    Leigh

    Sounds OK with me. To really position the image, is going to take some work, and if you trust the users to do the "right" thing, then you are in luck.

    Give them a message box telling them what to do, and save yourself a lot of work. But if you really want to do a great job, the members can help you figure it out.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

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