Forum Discussion
VBA Excel Macro - Picture attached to Cell (insert) - Not link
I found a partial work around ... but it's horrible to think this has to be done.
You can use the first option to insert the pictures / attached to cells as links, then convert it to a PDF. The PDF can be sent, etc. Then convert it from PDF back to an Excel file. While this seems like a really bad work around, I haven't found any other options yet.
Gstg72 did you ever find a fix to this? I am trying to have a visible file inserted from a path, but im not great at coding for excel or using it yet. I've used it for years but only recently learned some of what you're able to do. I've taken SQL classes, but I still have no clue what im doing. The few things i've tried did not work. I dont need to sort mine, I just need a visible image inserted in place of file paths already inserted into the spreadsheet, OR I need them inserted in a column next to. BUT, I have multiple images for each item in a row, so I'm not sure if i would need to add additional columns or additional rows. But I know I need the actual image in the spreadsheet. There are a few thousand, so I do NOT want to have to do it all manually if I can avoid it. I wrote a code to retrieve the images and it took months to get it right, but I don't have that kind of time for this. Ive tried ablebits and I just get errors. I've tried a macros code or two and got errors with that as well. 😕
If you have any suggestions i'd love to hear them. If you need any specific or additional info just let me know!