Forum Discussion
Solved
Embedding a picture with breaking links does not work
Apologies in advance if I don't format this discussion properly. I'm a bit of a newbie to forums. I've automated (still prototyping) some expense report procedures. One requirement is to attach...
Change
Set Ol = ActiveSheet.OLEObjects.Add(Filename:=fnameAndPath, Link:=False, DisplayAsIcon:=False)to
ActiveSheet.Shapes.AddPicture Filename:=fnameAndPath, LinktoFile:=False, _ SaveWithDocument:=True, Left:=10, Top:=10, Width:=400, Height:=300Adjust the position and size as needed.
Change
Set Ol = ActiveSheet.OLEObjects.Add(Filename:=fnameAndPath, Link:=False, DisplayAsIcon:=False)
to
ActiveSheet.Shapes.AddPicture Filename:=fnameAndPath, LinktoFile:=False, _
SaveWithDocument:=True, Left:=10, Top:=10, Width:=400, Height:=300Adjust the position and size as needed.
Thanks for the help - I'd already begun going down the "addpicture" path for a bit. I'll test
