Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2014-08-27 Thread Vaibhav Joshi
Welcome Marty On Aug 27, 2014 10:56 PM, "Marty Girvan" wrote: > hello, My name is Marty and I work at Boeing in Washington. I use Excel, > VBA and some other tools for daily tasks. Glad to see all the contributors > and posts. Let the learning begin. > > Marty > > -- > Are you =EXP(E:RT) or =N

$$Excel-Macros$$ Re: Create macro to save macro template as macro enabled workbook using cell value as file name

2014-08-27 Thread rich johnson
This works thanks Gawli Anil. On Saturday, August 23, 2014 12:35:08 PM UTC-5, rjag...@aim.com wrote: > > *Create macro to save macro template as macro enabled workbook using cell > value as file name* > > This is what I'm trying to do. Save the Macro Template on a network > drive as a Macro

$$Excel-Macros$$ EXCEL/PPT Macros

2014-08-27 Thread Marty Girvan
So... I am working on some code in Excel to create some automation. My goal is for a macro to run and create a new PowerPoint presentation and to then open 5 PowerPoint slides in the excel sheet and place them into the presentation in the order they are listed in the excel file. I have an

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2014-08-27 Thread Paul Schreiner
Welcome!   I am Paul Schreiner, working at Allison Transmission in Indianapolis, Indiana. I maintain over 120,000 lines of VBA code in multiple manufacturing applications.   If/when you have a question, bring it on!  Paul - “Do all the good you can, By all

$$Excel-Macros$$ Re: Introduce Yourself !!

2014-08-27 Thread Marty Girvan
hello, My name is Marty and I work at Boeing in Washington. I use Excel, VBA and some other tools for daily tasks. Glad to see all the contributors and posts. Let the learning begin. Marty -- 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) ! J

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

2014-08-27 Thread Paul Schreiner
In my opinion, a person that asks this type of question (especially in an interview) seems to be more interested in "book" knowledge instead of "practical" knowledge.    To me, it's not as important that you know the answer to a question like this, but that you know where to FIND the answer to a

Re: $$Excel-Macros$$ sharing of excel workbook

2014-08-27 Thread Hilary Lomotey
its a lot of macro for different functions can it be done by your suggestion? On Wed, Aug 27, 2014 at 2:35 PM, Vaibhav Joshi wrote: > Hi > > Try converting macro to excel add-in & can install it to all user. I am > not sure but it might work. > > Cheers!! > > > On Wed, Aug 27, 2014 at 6:57 PM,

Re: $$Excel-Macros$$ sharing of excel workbook

2014-08-27 Thread Vaibhav Joshi
Hi Try converting macro to excel add-in & can install it to all user. I am not sure but it might work. Cheers!! On Wed, Aug 27, 2014 at 6:57 PM, Hilary Lomotey wrote: > Hello Experts, > > i have an excel templates where i want users to be able to access it > almost at the smae time if the so

$$Excel-Macros$$ sharing of excel workbook

2014-08-27 Thread Hilary Lomotey
Hello Experts, i have an excel templates where i want users to be able to access it almost at the smae time if the so wish so i activated the share workbook option on the review menu, however, its giving an error because the template contains macro and it says macros cannot be shared, pls is there

$$Excel-Macros$$ VBA Interview Question

2014-08-27 Thread Chandra Shekar
Hi, One of my colleague went for an interview and they asked How many types of variables are there in VBA? Could you please let me know answer to this question and can anyone share VBA questionaries for interview? Thanks in advance. Regards, Chandru -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) i

Re: $$Excel-Macros$$ Create user wise feedback sheet

2014-08-27 Thread Vaibhav Joshi
Cheers!! On Wed, Aug 27, 2014 at 1:24 PM, SG wrote: > Vabz sir, thanku so much > really you helped me alot...Hats off:) > > > On Tuesday, August 26, 2014 11:46:12 PM UTC+5:30, Vabz wrote: > >> place all sheets to be updated in one folder, run macro & select that >> folder, & data will get c

Re: $$Excel-Macros$$ Create user wise feedback sheet

2014-08-27 Thread SG
Vabz sir, thanku so much really you helped me alot...Hats off:) On Tuesday, August 26, 2014 11:46:12 PM UTC+5:30, Vabz wrote: > > place all sheets to be updated in one folder, run macro & select that > folder, & data will get consolidated in this book. > > Cheers!! > > > On Tue, Aug 26, 2014

Re: $$Excel-Macros$$ CCare Log Mgnt Sys

2014-08-27 Thread veeru h
Like Meeting Hall Table 180 is President all B columns nos Members ( with their detail Data) ie pivot sir pls do as your imagine bcoz ur idea's faster than others On Wed, Aug 27, 2014 at 12:29 PM, veeru h wrote: > Sir, > > Chart 2 is Model of Pivot Data > if not possible mobile icons w

Re: $$Excel-Macros$$ CCare Log Mgnt Sys

2014-08-27 Thread veeru h
Sir, Chart 2 is Model of Pivot Data if not possible mobile icons with b column no atleast to show that details table ex: main cell is 180 and others are B columns no details group(pivot) thank you On Wed, Aug 27, 2014 at 10:44 AM, Vaibhav Joshi wrote: > Hi > > your requirement is