Adding an Image File (Excell All)

Topic

New Reply

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

Reply | Quote

Replies

Leigh

You can do something like:

ActiveSheet.OLEObjects.Add(FileName:= “ String containing the path and name of object [/i]” , 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

Reply | Quote

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

Reply | Quote

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

Reply | Quote