$$Excel-Macros$$ Help with sending file as an email with vba

2015-09-09 Thread gargee singh
Dear Experts , I need help with the below code. This code emails the current active file as an attachment while also copying a specific range of cells from the sheet. It works fine except that it removes the user signature. I want to pick the user signature. Sub sumit() Dim outapp

$$Excel-Macros$$ Re: EXCEL FILE WITH MACRO TO GENERATE SUMMARY REPORT

2015-09-09 Thread Nasir Saikh
Dear Siraj, Can you please share a sample which type summary you required. On Thursday, September 10, 2015 at 9:33:09 AM UTC+5:30, Siraj Momin (BHOG) wrote: > > Deal all > > > > Do any body have sample excel file with macro to generate summary report. > Which calculates the data > > > >

$$Excel-Macros$$ EXCEL FILE WITH MACRO TO GENERATE SUMMARY REPORT

2015-09-09 Thread Siraj Momin (BHOG)
Deal all Do any body have sample excel file with macro to generate summary report. Which calculates the data Regards, Siraj This email and any attachments to it may be confidential and are intended solely for the use of the recipient(s). If you are not the

Re: $$Excel-Macros$$ terms

2015-09-09 Thread GENIUS
I appreciate the time you gave me for my problem and giving me the support. On Wednesday, 9 September 2015 20:19:38 UTC+5, Paul Schreiner wrote: > > Again, not a problem. > The biggest issue you run into when asking for help is that > YOU know what it is you're looking for, but when you ask a que

Re: $$Excel-Macros$$ Creating Macro

2015-09-09 Thread Paul Schreiner
Actually Vinay's answer is complete.It's your question that is incomplete. You asked:Is it possible? Vinay is correct.  Yes, it is. Your "statement of intent" is unclear. You said "I want to create a Macro"  That's pretty clear. Go right ahead, let us know how that works out. then: " cells that be

Re: $$Excel-Macros$$ terms

2015-09-09 Thread Paul Schreiner
Again, not a problem.The biggest issue you run into when asking for help is that YOU know what it is you're looking for, but when you ask a question, you must communicate everything that you already know. That is: you wish to do something with some data.What does the data look like?where did it

Re: $$Excel-Macros$$ Creating Macro

2015-09-09 Thread Mesut Yilmaz
Can you explain? Op woensdag 9 september 2015 10:01:58 UTC+2 schreef Vinay Saraf: > > yes > > On Wed, Sep 9, 2015 at 1:00 PM, Mesut Yilmaz > wrote: > >> Hello All, >> >> I want to create a Macro that, cells that beginning with *, that he >> automatically deleting all that cells.. Is that posible

Re: $$Excel-Macros$$ Help Required

2015-09-09 Thread Abhishek Jain
Noticed that the time mentioned for "seconds" part is differentiated by a decimal while it should be a colon (like it is done for the hours-minutes part) so as to enable excel to read it as "time". Once you correct that, you can simply deduct the down time from up time to get the difference and set

Re: $$Excel-Macros$$ help required to assign number value

2015-09-09 Thread Abhishek Jain
Assuming that your values are stored in column A from cell 1 to 50, you could use this formula in cell B1 and drag it down - =RANK(A1,$A$1:$A$50) HTH Abhishek On Wed, Sep 9, 2015 at 2:22 PM, Nasir Saikh wrote: > Hi Experts, > > I need a formula to assign number value example is given below wh

$$Excel-Macros$$ Help Required

2015-09-09 Thread Neeraj Chauhan
Dear Experts, I want total duration time DATETIME_UP DATETIME_DOWN Total Duration Required 9/1/2015 04:06.5 9/1/2015 05:04.1 HRS:MIN:SS -- 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

$$Excel-Macros$$ help required to assign number value

2015-09-09 Thread Nasir Saikh
Hi Experts, I need a formula to assign number value example is given below where i need is if the value is max then assign 4, below that 3, below that 2, below that 1 Value 1000 1 100 10 required 43 1 2 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in E

Re: $$Excel-Macros$$ terms

2015-09-09 Thread GENIUS
On Tuesday, 8 September 2015 16:47:00 UTC+5, Paul Schreiner wrote: > > First of all, learning by yourself is admirable! > There are lots tools that help. > > The one I use the absolute MOST is the HELP within the VBA editor. > > In the upper right of the editor window, you'll see a box that says

Re: $$Excel-Macros$$ Creating Macro

2015-09-09 Thread Vinay Saraf
yes On Wed, Sep 9, 2015 at 1:00 PM, Mesut Yilmaz wrote: > Hello All, > > I want to create a Macro that, cells that beginning with *, that he > automatically deleting all that cells.. Is that posible? > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:

$$Excel-Macros$$ Creating Macro

2015-09-09 Thread Mesut Yilmaz
Hello All, I want to create a Macro that, cells that beginning with *, that he automatically deleting all that cells.. Is that posible? -- 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.f