Insert Image

[Brendon87]

Hi all

I am trying to get the shapes.AddPicture function to work.

I have tried two methods of input which from my searching should do the same thing, granted I am new to VBA so I may be misinterpreting. Any help would be greatly appreciated!

first method code:
With ActiveSheet.Shapes.AddPicture("G:\__Logos - BD\Safire\4. Safire Triangle\Safire Triangle (Blue) Side by Side (transparent).jpg", msoFalse, msoTrue, 50, 50, 120, 80)

error: Application-defined or object-defined error

second method code:
With ActiveSheet.Shapes.AddPicture()
Filename = "G:\__Logos - BD\Safire\4. Safire Triangle\Safire Triangle (Blue) Side by Side (transparent).jpg"
LinktoFile = msoFalse
SavewithDocument = MsoTriState
Left = 50
Top = 50
Width = 120
Height = 80
End With

error: Expected variable or procedure, not module

Regards

 

[RoryA]

Is the sheet protected, and are you certain that the path is correct?