Re: $$Excel-Macros$$ Access Interview Question

2014-09-16 Thread XLS S
Some general questions like 1) How many type of Join's and what is the difference between right,left and full join 2) what is cross tab 3) how to make pivot report or normal report like that . Enjoy Team XLS On Wed, Sep 17, 2014 at 2:04 AM, Rudra Thapa wrote: > Hi

Re: $$Excel-Macros$$ Excel to JSON

2014-09-16 Thread Vaibhav Joshi
Hi Check this site for more info: http://ramblings.mcpher.com/ Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Sep 16, 2014 at 11:55 PM, Rupesh Patil wrote: > > ​Hello Expert, > > I need your help VBA macro. > I have excel file, this file has 10 to

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

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

$$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 =EXP(E

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 6:4

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 wrote: > > > > > Thanks & Regards? >​​ > *​* > *Saleem Ansari* > > *Logicash Solutions Pvt. Ltd.* > *A-79| Sector-4| Noida| Gautam B

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