Re: $$Excel-Macros$$ Email Trigger ?

2013-10-07 Thread Bill Q
Correct ! On Monday, 7 October 2013 05:24:42 UTC-4, De Premor wrote: > > I think he want to check after data refreshed > > *I have a dynamic spreadsheet that monitors different stock prices > that is refreshed ever "x" amount of minutes.* > > On 07-10-2013 16:23, Ravinder wrote: > > U wan

$$Excel-Macros$$ Re: Email Trigger ?

2013-10-07 Thread Bill Q
HI Besole, I am impressed with your code. I will be really impressed once it works ! I read up a bit on the "Enable Reference> Object> Microsoft CDO for Windows 2000 Library". Sorry, but I am lost on this one and need guidence. I have put my email address and password where indicated and I lef

Re: $$Excel-Macros$$ Re: Multi sheets Grouping Problem

2013-10-07 Thread De Premor
Hi renuka, try to put this code on button1 on click event Private Sub CommandButton1_Click() Dim i As Integer, Str As String For i = 0 To ListBox1.ListCount - 1 If ListBox1.Selected(i) Then Str = Str & IIf(Len(Str) > 0, "|", "") & ListBox1.List(i) Next Sheets(Split(Str,

$$Excel-Macros$$ Re: Email Trigger ?

2013-10-07 Thread Basole
'hi, below option of sending email ( gmail ) without Outlook with SMTP server Sub SendEmail() ' Enable Reference> Object> Microsoft CDO for Windows 2000 Library Dim iMsg, iConf, Flds, nTo, nFr, rng, psw nTo = "your email address here" nFr = nTo rng = Range("a1").Value psw = "your email passwor

$$Excel-Macros$$ Re: Multi sheets Grouping Problem

2013-10-07 Thread renuka chari
Dear group any update. please help me out thanks On Sunday, 6 October 2013 18:11:35 UTC+5:30, renuka chari wrote: > > Dear Group > > Please help me this problem for multi sheets select with in the single > click > As per the requirement > > Thank > > *(¨`•.•´¨) Always > `•.¸(¨`•.•´¨) Ke

Re: $$Excel-Macros$$ Fwd: DATE VALIDATE FOR THE FORMULA GIVEN IN THE CELL

2013-10-07 Thread Grkrishna Naidu
Thanks a lot GRKRISHNA On Mon, Oct 7, 2013 at 5:02 PM, Ravinder wrote: > > =IF(TODAY()>$F$3,"",IF(ISERROR(IF(MOD(D6,G6)=0,(D6/G6)*H6,ROUNDDOWN(D6/G6,0)*H6)),"",(IF(MOD(D6,G6)=0,(D6/G6)*H6,ROUNDDOWN(D6/G6,0)*H6 > > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macro

$$Excel-Macros$$ Re: Complicated Formula (automatic add back)

2013-10-07 Thread Rs.
Amar, You want to add the Balance Qty with your Received Qty (ie in Cell F7) But where you key-in (on which cell) your second receipt for "A"?? Regards Rs. -- 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 f

RE: $$Excel-Macros$$ Fwd: DATE VALIDATE FOR THE FORMULA GIVEN IN THE CELL

2013-10-07 Thread Ravinder
=IF(TODAY()>$F$3,"",IF(ISERROR(IF(MOD(D6,G6)=0,(D6/G6)*H6,ROUNDDOWN(D6/G6,0) *H6)),"",(IF(MOD(D6,G6)=0,(D6/G6)*H6,ROUNDDOWN(D6/G6,0)*H6 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Grkrishna Naidu Sent: Monday, October 07, 2013 1:32 PM To: excel-ma

Re: $$Excel-Macros$$ Complicated Formula (automatic add back)

2013-10-07 Thread amar takale
Dear Experts Pls anybody guide me on this issue Regards Amar On Mon, Oct 7, 2013 at 11:35 AM, amar takale wrote: > Dear Ravinder > Actually I want Previous balance Quantity of A ( 5 unit) in cell H23 to > add this 5 Quantity in next cell F27 Same Name A means total Received > Quantity+Previo

RE: $$Excel-Macros$$ Email Trigger ?

2013-10-07 Thread Ravinder
PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Bill Q Sent: Monday, October 07, 2013 2:05 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Email Trigger ? Hi, I am using Excel 2007 and have Gmail as my primary email account.

RE: $$Excel-Macros$$ Email Trigger ?

2013-10-07 Thread Ravi Kumar
Do u have any sample data, then plz provide Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ravinder Sent: Monday, October 07, 2013 2:59 PM To: excel-macros@googlegroups.com Cc: Soum Subject: RE: $$Excel-Macros$$ Email

RE: $$Excel-Macros$$ Email Trigger ?

2013-10-07 Thread Ravinder
Ok thanks.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of De Premor Sent: Monday, October 07, 2013 2:55 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Email Trigger ? I think he want to check after data refreshed I have a dy

Re: $$Excel-Macros$$ Email Trigger ?

2013-10-07 Thread De Premor
I think he want to check after data refreshed */I have a dynamic spreadsheet that monitors different stock prices that is refreshed ever "x" amount of minutes./* On 07-10-2013 16:23, Ravinder wrote: U want this in which event like when u change value of sheet or do some calculation or open

RE: $$Excel-Macros$$ Email Trigger ?

2013-10-07 Thread Ravinder
U want this in which event like when u change value of sheet or do some calculation or open file or activate sheet or any specific time ? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Bill Q Sent: Monday, October 07, 2013 2:05 AM To: excel-macros@google

$$Excel-Macros$$ Fwd: DATE VALIDATE FOR THE FORMULA GIVEN IN THE CELL

2013-10-07 Thread Grkrishna Naidu
Dear Experts ** ** I need a help to validate the formula/ function given in the column “E” ** ** The bonus offer is valid upto 7th October 2013function should not execute the bonus offer if the system date as after 8th October 2013 ** ** DATE 7/10/2013 *Product Co