Insert Transparent .PNG Signature to Workbook?

[ascalise]

Is this possible? Have a few templates I'm looking to add dynamic signatures to from a dropdown and save to .PDF instead of printing, manually signing and scanning in. I have signature images in PNG format that I'm looking to overlay over the signature line.

I've looked into the INSERT>SIGNATURE functionality built into Excel but it lacks the flexibility I require.

I already saw that I can insert and place/format pictures with the following code from a local directory (as PicPath):

With xlApp.ActiveSheet.Pictures.Insert(PicPath)
    With .ShapeRange
        .LockAspectRatio = msoTrue
        .Width = 75
        .Height = 100
    End With
    .Left = xlApp.ActiveSheet.Cells(i, 20).Left
    .Top = xlApp.ActiveSheet.Cells(i, 20).Top
    .Placement = 1
    .PrintObject = True
End With

 

[Dan_W]

What is wrong with the code you provided? I had to adjust it slightly for the fact that it is incomplete, but other than that it seems to work ok.

Sub AddImagePNG()
    Dim PicPath As String
    PicPath = "E:\TransparentPicturePath.png"
    With Application.ActiveSheet.Pictures.Insert(PicPath)
        With .ShapeRange
            .LockAspectRatio = msoTrue
            .Width = 75
            .Height = 100
        End With
        .Left = ActiveSheet.Cells(2, 2).Left
        .Top = ActiveSheet.Cells(2, 2).Top
        .Placement = 1
        .PrintObject = True
    End With
End Sub

I've looked into the INSERT>SIGNATURE functionality built into Excel but it lacks the flexibility I require.

Also, what flexibility do you require that the inbuilt option lacks?