Insert Muliple Embed Objects VBA Code

[Closed]
Report
Posts
2
Registration date
Friday September 20, 2013
Status
Member
Last seen
September 21, 2013
-
Posts
2779
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 29, 2021
-
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

Posts
2779
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 29, 2021
468
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!