Avatar of flemingg62
flemingg62
 asked on

Embed a image in to an Excel Spreadsheet

Hi I have the following code (In attached file)  that insets image into an excel spreadsheet, but when I sent to others, thy can't see the images. So I need to modify the code to embed the images instead of linking to them
The code( line 40+) to inset images is:
            If Dir(fNameAndPath) <> "" Then
                Set img = .Pictures.Insert(fNameAndPath)
                With img
                   .Left = ActiveSheet.Cells(lngRow, PHOTO).Left
                   .Top = ActiveSheet.Cells(lngRow, PHOTO).Top
                   .Width = ActiveSheet.Cells(lngRow, PHOTO).Width
                   .Height = ActiveSheet.Cells(lngRow, PHOTO).Height
                   .Placement = 1
                   .PrintObject = True

Furniture to Photos.xlsm
VBA

Avatar of undefined
Last Comment
flemingg62

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Bembi

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
flemingg62

ASKER
Hi
Perfect
Your help has saved me hundreds of hours of internet surfing.
fblack61