Insert Muliple Embed Objects VBA Code

Closed
minhhan Posts 2 Registration date Friday September 20, 2013 Status Member Last seen September 21, 2013 - Sep 21, 2013 at 11:03 PM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Sep 23, 2013 at 11:42 AM
Hello,
I am looking for a script that will automatically insert muliple embed objects to cells in excel
And this is my case:

- I have a sheet with a list name of pics in column B4. And I want store embed objects in cells at column C4
- I was stored images in D:\image\ with extension .tif
anh this is screenshot my sheet in excel
https://farm3.staticflickr.com/2888/9847440574_d249eb2864.jpg
and my folder path
https://farm3.staticflickr.com/2878/9847344004_9efc4b4ae7.jpg

I really appreciate if someone can help me. Thanks you!
Sorry for my English and expression. ^^

1 reply

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Sep 23, 2013 at 11:42 AM
Hi Minhhan,

This query comes close to yours:
https://ccm.net/forum/affich-716722-insert-picture-in-excel-macro-which-takes-the-file-name-refrence

Let me know if further assistance is needed.

Best regards,
Trowa
0