Import Picture by VBA according to name

3 views
Skip to first unread message

Ashish Kumar

unread,
May 23, 2015, 4:28:31 AM5/23/15
to Excel...@googlegroups.com
Dear Group Members,


PFA...!!!

If you have Product name in 1st column and you want to insert images in 2nd column according to your product name, then this is for you.

Steps:

Place all images in one folder
Paste folder path in VBA Module 
Paste image names in B column
Hit blue button for run the macro.


Note:

Image names which are in folder and image names which are in Excel Sheet Should be same



Regards
Ashish Kumar
Paste images.xlsm

Ashu k

unread,
May 24, 2015, 10:38:47 AM5/24/15
to Excel...@googlegroups.com
Dear Ashish Sir,

IT's Superb...!!

It's very unique and useful. Thanks for sharing.


Thanks & Regards
Ashu Kenith

Ashish Kumar

unread,
May 24, 2015, 10:48:34 AM5/24/15
to Excel...@googlegroups.com
Welcome...!!


Regards
Ashish Kumar

YS Yeoh

unread,
May 24, 2015, 9:04:52 PM5/24/15
to Excel...@googlegroups.com
Dear Ashish,

Thank you very much for your help.

From
YS Yeoh

YS Yeoh

unread,
May 24, 2015, 11:57:09 PM5/24/15
to Excel...@googlegroups.com
Dear Ashish,

Just wondering if there any website could re-learn VBA?

From 
YS Yeoh

Vim-Personal

unread,
May 24, 2015, 11:59:54 PM5/24/15
to Excel...@googlegroups.com

I have used this as my guide:

 

http://www.homeandlearn.org/

 

 

_

Regards

Vimlesh Chetty

<Sent via Outlook>

--
You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.
To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/b5e48720-50d7-48d5-bd45-27934a272324%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Ashish Kumar

unread,
May 25, 2015, 1:44:59 AM5/25/15
to Excel...@googlegroups.com
Dear YS Yeoh,

Welcome...!!


Regards
Ashish Kumar

Ashish Kumar

unread,
May 25, 2015, 1:51:57 AM5/25/15
to Excel...@googlegroups.com
Dear YS Yeoh,

Stay connected with us.

Share knowledge and gain Knowledge.


Regards
Ashish Kumar

On 25/05/2015, YS Yeoh <ysye...@gmail.com> wrote:
Reply all
Reply to author
Forward
0 new messages