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 wrote: > exactly.. > > On Tue, Sep 16, 2014 at 12:27 PM, Vaibhav Joshi wrote: > >> Is your pic stored in folder & you want t

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 ActiveSheet

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

2014-09-16 Thread Deepak Rawat
exactly.. On Tue, Sep 16, 2014 at 12:27 PM, Vaibhav Joshi 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 > wrote: > >> there is no sa

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

2014-09-15 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 wrote: > there is no sample file i have > I will import some pictures from a folder n get the name of tha

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

2014-09-15 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 wrote: > can you share sample excel file > > + > *I did not do this for you. God is here working through me for you.* > > On Tue, S

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

2014-09-15 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 wrote: > 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

$$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 shp