Inserting an image from Windows Explorer

[LarryM]

Hello again, I'm a huge fan of this site and always try to search for my needs before posting. Unfortunately, I've been unable to find an answer.

I just need the VBA code that will insert a TIF file from a directory in Windows Explorer into a worksheet. I'll need to position it and resize the image too but I think I can figure that out.

For reference, let's just say the TIF files reside on C:\TIF Files.

Thanks in advance!

 

[VoG]

Here's an example

Sub piccy()
ActiveSheet.Pictures.Insert ("C:\TIF Files\pic.tif")
With ActiveSheet.Shapes(ActiveSheet.Shapes.Count)
    .LockAspectRatio = False
    .Top = Range("C3").Top
    .Left = Range("C3").Left
    .Height = Range("C3").RowHeight
    .Width = Range("C3").Width
End With
End Sub

 

[LarryM]

So simple now that I see it. I know enough VBA to be dangerous. Never had any training.

Thank you very much!!!