Re: $$Excel-Macros$$ Get photographs name

2014-09-16 Thread Vaibhav Joshi
can you share sample excel file + *I did not do this for you. God is here working through me for you.* On Tue, Sep 16, 2014 at 11:10 AM, Deepak Rawat deepakexce...@gmail.com wrote: Hi, I need to get photograph names in excel I tried , i insert all the pictures in to excel and run the

Re: $$Excel-Macros$$ Get photographs name

2014-09-16 Thread Deepak Rawat
there is no sample file i have I will import some pictures from a folder n get the name of that images Regards, On Tue, Sep 16, 2014 at 11:58 AM, Vaibhav Joshi v...@vabs.in wrote: can you share sample excel file + *I did not do this for you. God is here working through me for you.* On

Re: $$Excel-Macros$$ Get photographs name

2014-09-16 Thread Vaibhav Joshi
Is your pic stored in folder you want to list name of that pics?? + *I did not do this for you. God is here working through me for you.* On Tue, Sep 16, 2014 at 12:20 PM, Deepak Rawat deepakexce...@gmail.com wrote: there is no sample file i have I will import some pictures from a folder

Re: $$Excel-Macros$$ Get photographs name

2014-09-16 Thread Deepak Rawat
exactly.. On Tue, Sep 16, 2014 at 12:27 PM, Vaibhav Joshi v...@vabs.in wrote: Is your pic stored in folder you want to list name of that pics?? + *I did not do this for you. God is here working through me for you.* On Tue, Sep 16, 2014 at 12:20 PM, Deepak Rawat deepakexce...@gmail.com

Re: $$Excel-Macros$$ Get photographs name

2014-09-16 Thread Vaibhav Joshi
If you have imported pics in excel file then name of file is stored in .AlternativeText field. so instead of .Name use .AlternativeText this will solve purpose. So new code is for images imported to excel file: Sub GetShapeNames() Dim shp As Shape Dim i As Long i = 1 For Each shp In

Re: $$Excel-Macros$$ Get photographs name

2014-09-16 Thread Vaibhav Joshi
Check this.. Your second requirement.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 16, 2014 at 2:01 PM, Deepak Rawat deepakexce...@gmail.com wrote: exactly.. On Tue, Sep 16, 2014 at 12:27 PM, Vaibhav Joshi v...@vabs.in wrote: Is your pic

$$Excel-Macros$$ Get photographs name

2014-09-15 Thread Deepak Rawat
Hi, I need to get photograph names in excel I tried , i insert all the pictures in to excel and run the below macro but its givint names like Picture 1, Pcture 2.. But i need the actural picture name (I think we say it caption name) Kindly provide the solution Sub GetShapeNames() Dim