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

Re: $$Excel-Macros$$ naming rang WITH FOURMULA

2014-09-16 Thread Vaibhav Joshi
hi Saleem not clear what you want? + *I did not do this for you. God is here working through me for you.* On Tue, Sep 16, 2014 at 12:59 PM, Saleem Ansari saleem.logic...@gmail.com wrote: Thanks Regards? ​​ *​* *Saleem Ansari* *Logicash Solutions Pvt. Ltd.* *A-79| Sector-4|

Re: $$Excel-Macros$$ VBA required - Finding duplicates and adding all in one new worksheet

2014-09-16 Thread Vaibhav Joshi
cant we do other way around!! I guess you must be having list of alpha numeric word, you can put that in works sheet next to each ref to sheets where it appears will get populated!! Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 16, 2014 at

$$Excel-Macros$$ Excel to JSON

2014-09-16 Thread Rupesh Patil
​Hello Expert, I need your help VBA macro. I have excel file, this file has 10 to 25 user's records​, each user has 414 column records(A:OX) what I want is that convert excel row of each user record to JSON. -- Thanks Regards, Rupesh Patil, (9970196189), Ayushman Pvt. Ltd. -- Are you

$$Excel-Macros$$ Access Interview Question

2014-09-16 Thread Rudra Thapa
Hi All, Can you please provide me access Interview Question -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

$$Excel-Macros$$ Re: Macro Stop start (pause) Timer

2014-09-16 Thread Bill Q
Unfortunately, I am getting the following error when pressing the strat button in the spreadhseet: Compile error: Duplicate declaration of current scope It highlight wshShell As Object as the problem. I tried it a few times. When I run the running macro1 directly - it does nothing. The