I have excel with images in cells. When send the file to other it shows broken links as I just imbedded the excel sheet. So I have more than 150 pictures as I want any vba solution if images are linked then embed.
Non-linked picture gives “linked image cannot be displayed” (1 Viewer)
- Thread starter rehanemis
- Start date
- Local time
- Today, 09:04
- Joined
- Feb 28, 2001
- Messages
- 27,205
If the cells's images were linked then of course you would need to send the external images to go with the workbook.
One solution might be that you have the links as relative to the current workbook location. I.e. instead of C:\MyPics\JoeSchlabotnik.JPG you could use .\XLPics\JoeSchlabotnik.JPG as the link reference. Then when you copy over the workbook, copy the subfolder. Make them a ZIP file or something like that and when you unzip, you not only copy the workbook but you copy the subfolder.
Note that I'm guessing as to your intention, but I am answering with a way for the pictures to follow the workbook if you are sharing by file copy. If that ISN'T what you meant, you'll have to be more specific.
One solution might be that you have the links as relative to the current workbook location. I.e. instead of C:\MyPics\JoeSchlabotnik.JPG you could use .\XLPics\JoeSchlabotnik.JPG as the link reference. Then when you copy over the workbook, copy the subfolder. Make them a ZIP file or something like that and when you unzip, you not only copy the workbook but you copy the subfolder.
Note that I'm guessing as to your intention, but I am answering with a way for the pictures to follow the workbook if you are sharing by file copy. If that ISN'T what you meant, you'll have to be more specific.
- Local time
- Today, 09:04
- Joined
- Feb 28, 2001
- Messages
- 27,205
Attachment didn't show up.
Using VBA to embed existing linked images into Excel (2010)
I have an exising report generated in excel which has a thumbnail of a linked .jpg file inside the 1st cell of every row. There are 100's of rows each with a unique thumbnail and assosiated .jpg file. This excel file needs to be distributed to several other people. When distributed all the image...
Personally I do it manually.
1- Click one of the images
2- press ctrl+A (to select all images)
3- Press ctrl+x (to cut all images)
4- Press ctrl+v
5- Without releasing the selected images, move one of the images to its previous location and unselect all images.
Last edited:
Not works
Using VBA to embed existing linked images into Excel (2010)
I have an exising report generated in excel which has a thumbnail of a linked .jpg file inside the 1st cell of every row. There are 100's of rows each with a unique thumbnail and assosiated .jpg file. This excel file needs to be distributed to several other people. When distributed all the image...www.mrexcel.com
Personally I do it manually.
1- Click one of the images
2- press ctrl+A (to select all images)
3- Press ctrl+x (to cut all images)
4- Press ctrl+v
5- Without releasing the selected images, move one of the images to its previous location and unselect all images.
Similar threads
