$$Excel-Macros$$ Re: Macro to copy data from a specif range from many closed workbooks in a folder to a master file creat

2014-04-18 Thread Dragomir Zhelev
*Everyone that needs to copy certain range of cells across numerous workbooks and summarize them into a master sheet can use the shared VBA code by Ashish. Great job, great forum. This is a code that saves more than 2 hours of manual work. VBA rules! * *Best* *D* On Wednesday, April 16,

$$Excel-Macros$$ Re: Macro to copy data from a specif range from many closed workbooks in a folder to a master file creat

2014-04-18 Thread Dragomir Zhelev
Dear Ashish, I just made some tests and it works perfectly and does exactly what I need it to, thanks so much man and God bless you! I wish one day I could write VBA code just like you. On Wednesday, April 16, 2014 9:52:01 PM UTC+3, Dragomir Zhelev wrote: > > Dear Excel and VBA lovers, > > Thi

Re: $$Excel-Macros$$ Re: Macro to copy data from a specif range from many closed workbooks in a folder to a master file creat

2014-04-18 Thread Dragomir Zhelev
Dear Ashish, Thank you so much for your code, for the effort and time dedicated.I am learning so your answer is much appreciated. I was quite busy recently and still had no the chance to test it. I will do it tonight. As my knowledge in VBA is pretty scarce at the moment and I am just in the mi

Re: $$Excel-Macros$$ Out Of Office

2014-04-18 Thread ashish koul
try this http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/A_3487-Automating-Out-of-Office-in-Outlook.html On Fri, Apr 18, 2014 at 10:52 PM, Bv Dileep wrote: > In current situation, OOO has to be manually edited and activated. At > times, we miss on updating as well

$$Excel-Macros$$ Out Of Office

2014-04-18 Thread Bv Dileep
In current situation, OOO has to be manually edited and activated. At times, we miss on updating as well as activatin OOO leading to miss on important communications. Macro which performs the following: - Everytime when user exits Outlook, it should give choice to user to activate OOO.

RE: $$Excel-Macros$$ 50 interview questions

2014-04-18 Thread Vikas Verma
Visit this http://mrexcel4u.blogspot.in/p/find-interview-questions.html From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Hanumant Sent: Friday, April 18, 2014 4:06 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ 50 interview quest

$$Excel-Macros$$ 50 interview questions

2014-04-18 Thread Hanumant
Hello group, long back somebody had posted document or link for 50 interview questions something like that. can somebody please repost it or anybody has some other document for interview questions. this is quiet urgent. thanks a lot. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do yo

Re: $$Excel-Macros$$ Additional Control

2014-04-18 Thread ashish koul
try this http://davaohandymom.blogspot.in/2013/05/solution-to-missing-not-showing.html On Fri, Apr 18, 2014 at 11:17 AM, Falina Gan wrote: > To Whom It May Concern, > > May I ask, why can;t we click the additional Controls to create a new > calender? Here is the image as below:- > > Thanks. >