Hey,
I'm on break for exam n doesn't have access to my PC/Lalptop.
I'll be able to see in to this not before sun eve or monday.
If sum one can help then would be great!!
Cheerz
Thanks::Vabs
Sent on my BlackBerry® from Vodafone
-----Original Message-----
From: Jayaprakash S <bhat.jayaprak...@gmail.com>
Sender: excel-macros@googlegroups.com
Date: Fri, 9 Nov 2012 11:03:17
To: <excel-macros@googlegroups.com>
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .
Hi Vabz,
Here with enclosing the file with VBA script which i'm currently using
(it is working for manual stuff but fails when data linked to
application)...
the Data what i'm talking about is linked to application and it will
get refreshed each second (Refer Yahoo-finance for more info on how
the data keeps changin in each seconds).
With your current code, it is sending e-mail on every refresh without
validating the Value condition (Using If condition to get an Value in
the enclosed file). Can you help me with Validating option ??
Cheers
JP.
On Thu, Nov 8, 2012 at 5:03 PM, VBA VABZ <v...@vabs.in> wrote:
> hi
>
> Happy to know that things are working after so much of struggle by you guyz.
>
> Add in teh begining
> Dim Fname as variant
>
> Before with statement add this line
> FName = ActiveWorkbook.Path & "\" & ActiveWorkbook.Name
>
> Between with statement add this line
> .Attachments.Add FName
>
> Cheerz//Vabs
>
>
>
>
> On Thu, Nov 8, 2012 at 4:46 PM, veerendra vanam <veerendra.va...@gmail.com>
> wrote:
>>
>> Dear Sir,
>>
>>
>> It's working fine but i need attached file also where give path
>> adreess in that macro code,,,,,,,,
>>
>> On Wed, Nov 7, 2012 at 7:08 PM, Vabz <v...@vabs.in> wrote:
>>>
>>> Hi Veerendra
>>>
>>> PFA this is designed to send email every 30secs.
>>>
>>> You can change linez to send evry hours
>>>
>>> Cheers//Vabs
>>>
>>> On Tuesday, November 6, 2012 6:00:55 PM UTC+5:30, Vabz wrote:
>>>>
>>>> Hi
>>>>
>>>> Send file with your code.
>>>>
>>>> Rgds//Vabs
>>>> On Tuesday, November 6, 2012 5:55:23 PM UTC+5:30, Jayaprakash S wrote:
>>>>>
>>>>> Hi Vabz,
>>>>>
>>>>> Nope, not giving the desired result... (attached the sample required
>>>>> file for more info)
>>>>>
>>>>>
>>>>> A) THIS PIVOT WILL GET AUTO REFRESHED (BASED ON GIVEN TIMINGS)
>>>>> B) ANY CHANGES IN THE TOTAL SHOULD SEND E-MAIL @ ONLY ONCE ( EXMPL:
>>>>> REFRESHED @ 9 :00 AM FOUND RAM : 200 AND AGAIN REFRESHED @ 9.20 AM AND
>>>>> OUND RAM : 200 - THEN, MAIL TO BE SENT @ 9: AM BUT NOT @ 9.20 AM)
>>>>> C) E-MAIL SHOULD BE OF AUTO GENERATED ONE WHICH IS BASED ON PIVOT
>>>>> VALUES (TO SEND E-MAIL I SHOULD NOT RUN ANY MACROS OR PRESS ANY BUTTON
>>>>> - AS AND WHEN PIVOT REFRESHES BASED ON ITS VALUE, IT SHOULD SHOOT AN
>>>>> AUTO GENERATED E-MAIL.
>>>>>
>>>>> thank you.
>>>>>
>>>>> JP.
>>>>>
>>>>>
>>>>> On Tue, Nov 6, 2012 at 5:20 PM, Vabz <v...@vabs.in> wrote:
>>>>> > Hi
>>>>> >
>>>>> > I have just tested & it workz..Pl update me form your end!!
>>>>> >
>>>>> > Rgds//Vabs
>>>>> >
>>>>> >
>>>>> > On Tuesday, November 6, 2012 5:15:26 PM UTC+5:30, Vabz wrote:
>>>>> >>
>>>>> >> Hi
>>>>> >>
>>>>> >> Ignore earlier & consider this
>>>>> >>
>>>>> >> Sub email()
>>>>> >> Dim myOutlook As Object
>>>>> >> Dim myMailItem As Object
>>>>> >> Dim FName As String
>>>>> >> Application.Calculate ' Make sure NOW() has been updated
>>>>> >>
>>>>> >> Set otlApp = CreateObject("Outlook.Application")
>>>>> >> Set otlNewMail = otlApp.CreateItem(olMailItem)
>>>>> >> FName = ActiveWorkbook.Path & "\" & ActiveWorkbook.NAME
>>>>> >> With otlNewMail
>>>>> >> .To = "v...@vabs.in"
>>>>> >> .CC = ""
>>>>> >> .Subject = "Test"
>>>>> >> .Body = "Test"
>>>>> >> .Attachments.add FName
>>>>> >> '.DeferredDeliveryTime = Range("A1")
>>>>> >> .Send
>>>>> >> End With
>>>>> >> Application.OnTime Now + TimeValue("00:10:00"), "email"
>>>>> >> Set otlNewMail = Nothing
>>>>> >> Set otlApp = Nothing
>>>>> >> Set otlAttach = Nothing
>>>>> >> Set otlMess = Nothing
>>>>> >> Set otlNSpace = Nothing
>>>>> >> End Sub
>>>>> >>
>>>>> >>
>>>>> >> On Tuesday, November 6, 2012 5:11:56 PM UTC+5:30, Vabz wrote:
>>>>> >>>
>>>>> >>> Hi
>>>>> >>>
>>>>> >>> Try this:
>>>>> >>>
>>>>> >>> Sub email()
>>>>> >>> Dim myOutlook As Object
>>>>> >>> Dim myMailItem As Object
>>>>> >>> Dim FName As String
>>>>> >>> Application.Calculate ' Make sure NOW() has been updated
>>>>> >>>
>>>>> >>> Set otlApp = CreateObject("Outlook.Application")
>>>>> >>> Set otlNewMail = otlApp.CreateItem(olMailItem)
>>>>> >>> FName = ActiveWorkbook.Path & "\" & ActiveWorkbook.NAME
>>>>> >>> With otlNewMail
>>>>> >>> .To = "v...@vabs.in"
>>>>> >>> .CC = ""
>>>>> >>> .Subject = "Test"
>>>>> >>> .Body = "Test"
>>>>> >>> .Attachments.add FName
>>>>> >>> .DeferredDeliveryTime = Range("A1")
>>>>> >>> .Send
>>>>> >>> End With
>>>>> >>> Application.OnTime Now + TimeValue("00:10:00"), "email"
>>>>> >>> Set otlNewMail = Nothing
>>>>> >>> Set otlApp = Nothing
>>>>> >>> Set otlAttach = Nothing
>>>>> >>> Set otlMess = Nothing
>>>>> >>> Set otlNSpace = Nothing
>>>>> >>> End Sub
>>>>> >>>
>>>>> >>>
>>>>> >> This wll sent email every ten minutes
>>>>> >> Rgds//vabs
>>>>> >>
>>>>> >>>
>>>>> >>> On Tuesday, November 6, 2012 5:00:01 PM UTC+5:30, Jayaprakash S
>>>>> >>> wrote:
>>>>> >>>>
>>>>> >>>> Dear Vabs,
>>>>> >>>>
>>>>> >>>> Thank you very much for spending your valuable time on my query...
>>>>> >>>>
>>>>> >>>> It is not giving me the required output... as it fails when :
>>>>> >>>>
>>>>> >>>> say for example :
>>>>> >>>>
>>>>> >>>> a) Refreshed @ 9.00 AM Data found as : 0
>>>>> >>>>
>>>>> >>>> b)Refreshed @ 9.10AM Data found as : Mr.Ram - 2
>>>>> >>>>
>>>>> >>>> c)Refreshed @ 9.20AM Data found as : Mr.Ram - 2
>>>>> >>>>
>>>>> >>>> in the above scence, @ 9 AM No e-mails as no Data and @ 9:10 AM
>>>>> >>>> E-mail
>>>>> >>>> to be sent and @ 9:20 AM again No E-mail as no change in the Value
>>>>> >>>> (also e-mail has already been sent @ 9.10 AM !!)
>>>>> >>>>
>>>>> >>>> Thank you.
>>>>> >>>>
>>>>> >>>> JP
>>>>> >>>>
>>>>> >>>> On Tue, Nov 6, 2012 at 4:13 PM, Vabz <v...@vabs.in> wrote:
>>>>> >>>> > Hi
>>>>> >>>> >
>>>>> >>>> > This will help you:
>>>>> >>>> >
>>>>> >>>> > Sub email()
>>>>> >>>> > Dim myOutlook As Object
>>>>> >>>> > Dim myMailItem As Object
>>>>> >>>> > Dim FName As String
>>>>> >>>> > Set otlApp = CreateObject("Outlook.Application")
>>>>> >>>> > Set otlNewMail = otlApp.CreateItem(olMailItem)
>>>>> >>>> > FName = ActiveWorkbook.Path & "\" & ActiveWorkbook.NAME
>>>>> >>>> > With otlNewMail
>>>>> >>>> > .To = "v...@vabs.in"
>>>>> >>>> > .CC = ""
>>>>> >>>> > .Subject = "Test"
>>>>> >>>> > .Body = "Test"
>>>>> >>>> > .Attachments.add FName
>>>>> >>>> > .DeferredDeliveryTime = Range("A1")
>>>>> >>>> > .Send
>>>>> >>>> > End With
>>>>> >>>> >
>>>>> >>>> > Set otlNewMail = Nothing
>>>>> >>>> > Set otlApp = Nothing
>>>>> >>>> > Set otlAttach = Nothing
>>>>> >>>> > Set otlMess = Nothing
>>>>> >>>> > Set otlNSpace = Nothing
>>>>> >>>> > End Sub
>>>>> >>>> >
>>>>> >>>> >
>>>>> >>>> > Where in you have to customise range A1 to give next delivery
>>>>> >>>> > time.
>>>>> >>>> >
>>>>> >>>> > Rgds//Vabs
>>>>> >>>> >
>>>>> >>>> > On Monday, November 5, 2012 10:54:30 PM UTC+5:30, veerendra
>>>>> >>>> > vanam
>>>>> >>>> > wrote:
>>>>> >>>> >>
>>>>> >>>> >> Dear Sir,
>>>>> >>>> >>
>>>>> >>>> >> i need automatic & send with attachment how its
>>>>> >>>> >> possible
>>>>> >>>> >> any
>>>>> >>>> >> one need help me,,,,,,,,,,,
>>>>> >>>> >>
>>>>> >>>> >>
>>>>> >>>> >> On Mon, Nov 5, 2012 at 10:49 PM, <koul....@gmail.com> wrote:
>>>>> >>>> >>>
>>>>> >>>> >>> Right now its manual effort . You need to click on button
>>>>> >>>> >>> every hour
>>>>> >>>> >>> Sent on my BlackBerry® from Vodafone
>>>>> >>>> >>> ________________________________
>>>>> >>>> >>> From: veerendra vanam <veerend...@gmail.com>
>>>>> >>>> >>> Sender: excel-...@googlegroups.com
>>>>> >>>> >>> Date: Mon, 5 Nov 2012 22:50:04 +0530
>>>>> >>>> >>> To: <excel-...@googlegroups.com>
>>>>> >>>> >>> ReplyTo: excel-...@googlegroups.com
>>>>> >>>> >>> Subject: Re: $$Excel-Macros$$ Send mail from outlook Every One
>>>>> >>>> >>> Hr .
>>>>> >>>> >>>
>>>>> >>>> >>> Thanks for reply in this code when i am run the macro every 1
>>>>> >>>> >>> hr
>>>>> >>>> >>> send
>>>>> >>>> >>> automatically or we click the button every 1 hr....plz tell
>>>>> >>>> >>> me,,
>>>>> >>>> >>>
>>>>> >>>> >>>
>>>>> >>>> >>> On Mon, Nov 5, 2012 at 10:43 PM, ashish koul
>>>>> >>>> >>> <koul....@gmail.com>
>>>>> >>>> >>> wrote:
>>>>> >>>> >>>>
>>>>> >>>> >>>> check the attachment see if it helps
>>>>> >>>> >>>>
>>>>> >>>> >>>>
>>>>> >>>> >>>> On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam
>>>>> >>>> >>>> <veerend...@gmail.com>
>>>>> >>>> >>>> wrote:
>>>>> >>>> >>>>>
>>>>> >>>> >>>>> Dear team
>>>>> >>>> >>>>>
>>>>> >>>> >>>>> i have data file in E drive i send mail to
>>>>> >>>> >>>>> every 1
>>>>> >>>> >>>>> hr
>>>>> >>>> >>>>> update mail.summary sheet in body ,,mail send every update
>>>>> >>>> >>>>> every 1
>>>>> >>>> >>>>> hr
>>>>> >>>> >>>>> 24hrs,365 days any macro from this type of works in vba,,,
>>>>> >>>> >>>>>
>>>>> >>>> >>>>> plz find attachment of sample file
>>>>> >>>> >>>>> --
>>>>> >>>> >>>>>
>>>>> >>>> >>>>> Thanks&Regards
>>>>> >>>> >>>>>
>>>>> >>>> >>>>> Veerendra.Vanam
>>>>> >>>> >>>>>
>>>>> >>>> >>>>> TOC TEAM
>>>>> >>>> >>>>> Bhagyanagar Electrical & Contractors
>>>>> >>>> >>>>> H.No-5-9-286/65,Plot No-65
>>>>> >>>> >>>>> Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,
>>>>> >>>> >>>>> Hyderabad-500072,-Andhra Pradesh
>>>>> >>>> >>>>> +91-9177-444-840,
>>>>> >>>> >>>>>
>>>>> >>>> >>>>> --
>>>>> >>>> >>>>> Join official facebook page of this forum @
>>>>> >>>> >>>>> https://www.facebook.com/discussexcel
>>>>> >>>> >>>>>
>>>>> >>>> >>>>> FORUM RULES (1120+ members already BANNED for violation)
>>>>> >>>> >>>>>
>>>>> >>>> >>>>> 1) Use concise, accurate thread titles. Poor thread titles,
>>>>> >>>> >>>>> like
>>>>> >>>> >>>>> Please
>>>>> >>>> >>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and
>>>>> >>>> >>>>> Need
>>>>> >>>> >>>>> Advice will
>>>>> >>>> >>>>> not get quick attention or may not be answered.
>>>>> >>>> >>>>>
>>>>> >>>> >>>>> 2) Don't post a question in the thread of another member.
>>>>> >>>> >>>>>
>>>>> >>>> >>>>> 3) Don't post questions regarding breaking or bypassing any
>>>>> >>>> >>>>> security
>>>>> >>>> >>>>> measure.
>>>>> >>>> >>>>>
>>>>> >>>> >>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>> >>>> >>>>>
>>>>> >>>> >>>>> 5) Cross-promotion of, or links to, forums competitive to
>>>>> >>>> >>>>> this
>>>>> >>>> >>>>> forum in
>>>>> >>>> >>>>> signatures are prohibited.
>>>>> >>>> >>>>>
>>>>> >>>> >>>>> 6) Jobs posting is not allowed.
>>>>> >>>> >>>>>
>>>>> >>>> >>>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is
>>>>> >>>> >>>>> not
>>>>> >>>> >>>>> allowed.
>>>>> >>>> >>>>>
>>>>> >>>> >>>>> NOTE : Don't ever post personal or confidential data in a
>>>>> >>>> >>>>> workbook.
>>>>> >>>> >>>>> Forum owners and members are not responsible for any loss.
>>>>> >>>> >>>>> ---
>>>>> >>>> >>>>> You received this message because you are subscribed to the
>>>>> >>>> >>>>> Google
>>>>> >>>> >>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>>> >>>> >>>>> To post to this group, send email to
>>>>> >>>> >>>>> excel-...@googlegroups.com.
>>>>> >>>> >>>>> To unsubscribe from this group, send email to
>>>>> >>>> >>>>> excel-macros...@googlegroups.com.
>>>>> >>>> >>>>>
>>>>> >>>> >>>>> Visit this group at
>>>>> >>>> >>>>> http://groups.google.com/group/excel-macros?hl=en.
>>>>> >>>> >>>>>
>>>>> >>>> >>>>>
>>>>> >>>> >>>>
>>>>> >>>> >>>>
>>>>> >>>> >>>>
>>>>> >>>> >>>>
>>>>> >>>> >>>> --
>>>>> >>>> >>>> Regards
>>>>> >>>> >>>>
>>>>> >>>> >>>> Ashish Koul
>>>>> >>>> >>>>
>>>>> >>>> >>>>
>>>>> >>>> >>>> Visit
>>>>> >>>> >>>> http://www.excelvbamacros.com/
>>>>> >>>> >>>> http://www.accessvbamacros.com/
>>>>> >>>> >>>>
>>>>> >>>> >>>> P Before printing, think about the environment.
>>>>> >>>> >>>>
>>>>> >>>> >>>>
>>>>> >>>> >>>>
>>>>> >>>> >>>> --
>>>>> >>>> >>>> Join official facebook page of this forum @
>>>>> >>>> >>>> https://www.facebook.com/discussexcel
>>>>> >>>> >>>>
>>>>> >>>> >>>> FORUM RULES (1120+ members already BANNED for violation)
>>>>> >>>> >>>>
>>>>> >>>> >>>> 1) Use concise, accurate thread titles. Poor thread titles,
>>>>> >>>> >>>> like
>>>>> >>>> >>>> Please
>>>>> >>>> >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and
>>>>> >>>> >>>> Need
>>>>> >>>> >>>> Advice will
>>>>> >>>> >>>> not get quick attention or may not be answered.
>>>>> >>>> >>>>
>>>>> >>>> >>>> 2) Don't post a question in the thread of another member.
>>>>> >>>> >>>>
>>>>> >>>> >>>> 3) Don't post questions regarding breaking or bypassing any
>>>>> >>>> >>>> security
>>>>> >>>> >>>> measure.
>>>>> >>>> >>>>
>>>>> >>>> >>>> 4) Acknowledge the responses you receive, good or bad.
>>>>> >>>> >>>>
>>>>> >>>> >>>> 5) Cross-promotion of, or links to, forums competitive to
>>>>> >>>> >>>> this
>>>>> >>>> >>>> forum in
>>>>> >>>> >>>> signatures are prohibited.
>>>>> >>>> >>>>
>>>>> >>>> >>>> 6) Jobs posting is not allowed.
>>>>> >>>> >>>>
>>>>> >>>> >>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is
>>>>> >>>> >>>> not
>>>>> >>>> >>>> allowed.
>>>>> >>>> >>>>
>>>>> >>>> >>>> NOTE : Don't ever post personal or confidential data in a
>>>>> >>>> >>>> workbook.
>>>>> >>>> >>>> Forum owners and members are not responsible for any loss.
>>>>> >>>> >>>> ---
>>>>> >>>> >>>> You received this message because you are subscribed to the
>>>>> >>>> >>>> Google
>>>>> >>>> >>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>>> >>>> >>>> To post to this group, send email to
>>>>> >>>> >>>> excel-...@googlegroups.com.
>>>>> >>>> >>>> To unsubscribe from this group, send email to
>>>>> >>>> >>>> excel-macros...@googlegroups.com.
>>>>> >>>> >>>>
>>>>> >>>> >>>> Visit this group at
>>>>> >>>> >>>> http://groups.google.com/group/excel-macros?hl=en.
>>>>> >>>> >>>>
>>>>> >>>> >>>>
>>>>> >>>> >>>
>>>>> >>>> >>>
>>>>> >>>> >>>
>>>>> >>>> >>>
>>>>> >>>> >>> --
>>>>> >>>> >>>
>>>>> >>>> >>> Thanks&Regards
>>>>> >>>> >>>
>>>>> >>>> >>> Veerendra.Vanam
>>>>> >>>> >>>
>>>>> >>>> >>> TOC TEAM
>>>>> >>>> >>> Bhagyanagar Electrical & Contractors
>>>>> >>>> >>> H.No-5-9-286/65,Plot No-65
>>>>> >>>> >>> Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,
>>>>> >>>> >>> Hyderabad-500072,-Andhra Pradesh
>>>>> >>>> >>> +91-9177-444-840,
>>>>> >>>> >>>
>>>>> >>>> >>> --
>>>>> >>>> >>> Join official facebook page of this forum @
>>>>> >>>> >>> https://www.facebook.com/discussexcel
>>>>> >>>> >>>
>>>>> >>>> >>> FORUM RULES (1120+ members already BANNED for violation)
>>>>> >>>> >>>
>>>>> >>>> >>> 1) Use concise, accurate thread titles. Poor thread titles,
>>>>> >>>> >>> like
>>>>> >>>> >>> Please
>>>>> >>>> >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and
>>>>> >>>> >>> Need
>>>>> >>>> >>> Advice will
>>>>> >>>> >>> not get quick attention or may not be answered.
>>>>> >>>> >>>
>>>>> >>>> >>> 2) Don't post a question in the thread of another member.
>>>>> >>>> >>>
>>>>> >>>> >>> 3) Don't post questions regarding breaking or bypassing any
>>>>> >>>> >>> security
>>>>> >>>> >>> measure.
>>>>> >>>> >>>
>>>>> >>>> >>> 4) Acknowledge the responses you receive, good or bad.
>>>>> >>>> >>>
>>>>> >>>> >>> 5) Cross-promotion of, or links to, forums competitive to this
>>>>> >>>> >>> forum
>>>>> >>>> >>> in
>>>>> >>>> >>> signatures are prohibited.
>>>>> >>>> >>>
>>>>> >>>> >>> 6) Jobs posting is not allowed.
>>>>> >>>> >>>
>>>>> >>>> >>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is
>>>>> >>>> >>> not
>>>>> >>>> >>> allowed.
>>>>> >>>> >>>
>>>>> >>>> >>> NOTE : Don't ever post personal or confidential data in a
>>>>> >>>> >>> workbook.
>>>>> >>>> >>> Forum
>>>>> >>>> >>> owners and members are not responsible for any loss.
>>>>> >>>> >>> ---
>>>>> >>>> >>> You received this message because you are subscribed to the
>>>>> >>>> >>> Google
>>>>> >>>> >>> Groups
>>>>> >>>> >>> "MS EXCEL AND VBA MACROS" group.
>>>>> >>>> >>> To post to this group, send email to
>>>>> >>>> >>> excel-...@googlegroups.com.
>>>>> >>>> >>> To unsubscribe from this group, send email to
>>>>> >>>> >>> excel-macros...@googlegroups.com.
>>>>> >>>> >>>
>>>>> >>>> >>> Visit this group at
>>>>> >>>> >>> http://groups.google.com/group/excel-macros?hl=en.
>>>>> >>>> >>>
>>>>> >>>> >>>
>>>>> >>>> >>>
>>>>> >>>> >>> --
>>>>> >>>> >>> Join official facebook page of this forum @
>>>>> >>>> >>> https://www.facebook.com/discussexcel
>>>>> >>>> >>>
>>>>> >>>> >>> FORUM RULES (1120+ members already BANNED for violation)
>>>>> >>>> >>>
>>>>> >>>> >>> 1) Use concise, accurate thread titles. Poor thread titles,
>>>>> >>>> >>> like
>>>>> >>>> >>> Please
>>>>> >>>> >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and
>>>>> >>>> >>> Need
>>>>> >>>> >>> Advice will
>>>>> >>>> >>> not get quick attention or may not be answered.
>>>>> >>>> >>>
>>>>> >>>> >>> 2) Don't post a question in the thread of another member.
>>>>> >>>> >>>
>>>>> >>>> >>> 3) Don't post questions regarding breaking or bypassing any
>>>>> >>>> >>> security
>>>>> >>>> >>> measure.
>>>>> >>>> >>>
>>>>> >>>> >>> 4) Acknowledge the responses you receive, good or bad.
>>>>> >>>> >>>
>>>>> >>>> >>> 5) Cross-promotion of, or links to, forums competitive to this
>>>>> >>>> >>> forum
>>>>> >>>> >>> in
>>>>> >>>> >>> signatures are prohibited.
>>>>> >>>> >>>
>>>>> >>>> >>> 6) Jobs posting is not allowed.
>>>>> >>>> >>>
>>>>> >>>> >>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is
>>>>> >>>> >>> not
>>>>> >>>> >>> allowed.
>>>>> >>>> >>>
>>>>> >>>> >>> NOTE : Don't ever post personal or confidential data in a
>>>>> >>>> >>> workbook.
>>>>> >>>> >>> Forum
>>>>> >>>> >>> owners and members are not responsible for any loss.
>>>>> >>>> >>> ---
>>>>> >>>> >>> You received this message because you are subscribed to the
>>>>> >>>> >>> Google
>>>>> >>>> >>> Groups
>>>>> >>>> >>> "MS EXCEL AND VBA MACROS" group.
>>>>> >>>> >>> To post to this group, send email to
>>>>> >>>> >>> excel-...@googlegroups.com.
>>>>> >>>> >>> To unsubscribe from this group, send email to
>>>>> >>>> >>> excel-macros...@googlegroups.com.
>>>>> >>>> >>>
>>>>> >>>> >>> Visit this group at
>>>>> >>>> >>> http://groups.google.com/group/excel-macros?hl=en.
>>>>> >>>> >>>
>>>>> >>>> >>>
>>>>> >>>> >>
>>>>> >>>> >>
>>>>> >>>> >>
>>>>> >>>> >>
>>>>> >>>> >> --
>>>>> >>>> >>
>>>>> >>>> >> Thanks&Regards
>>>>> >>>> >>
>>>>> >>>> >> Veerendra.Vanam
>>>>> >>>> >>
>>>>> >>>> >> TOC TEAM
>>>>> >>>> >> Bhagyanagar Electrical & Contractors
>>>>> >>>> >> H.No-5-9-286/65,Plot No-65
>>>>> >>>> >> Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,
>>>>> >>>> >> Hyderabad-500072,-Andhra Pradesh
>>>>> >>>> >> +91-9177-444-840,
>>>>> >>>> >>
>>>>> >>>> > --
>>>>> >>>> > Join official facebook page of this forum @
>>>>> >>>> > https://www.facebook.com/discussexcel
>>>>> >>>> >
>>>>> >>>> > FORUM RULES (1120+ members already BANNED for violation)
>>>>> >>>> >
>>>>> >>>> > 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>> >>>> > Please
>>>>> >>>> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>> >>>> > Advice will
>>>>> >>>> > not get quick attention or may not be answered.
>>>>> >>>> >
>>>>> >>>> > 2) Don't post a question in the thread of another member.
>>>>> >>>> >
>>>>> >>>> > 3) Don't post questions regarding breaking or bypassing any
>>>>> >>>> > security
>>>>> >>>> > measure.
>>>>> >>>> >
>>>>> >>>> > 4) Acknowledge the responses you receive, good or bad.
>>>>> >>>> >
>>>>> >>>> > 5) Cross-promotion of, or links to, forums competitive to this
>>>>> >>>> > forum
>>>>> >>>> > in
>>>>> >>>> > signatures are prohibited.
>>>>> >>>> >
>>>>> >>>> > 6) Jobs posting is not allowed.
>>>>> >>>> >
>>>>> >>>> > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
>>>>> >>>> > allowed.
>>>>> >>>> >
>>>>> >>>> > NOTE : Don't ever post personal or confidential data in a
>>>>> >>>> > workbook.
>>>>> >>>> > Forum
>>>>> >>>> > owners and members are not responsible for any loss.
>>>>> >>>> > ---
>>>>> >>>> > You received this message because you are subscribed to the
>>>>> >>>> > Google
>>>>> >>>> > Groups
>>>>> >>>> > "MS EXCEL AND VBA MACROS" group.
>>>>> >>>> > To post to this group, send email to excel-...@googlegroups.com.
>>>>> >>>> > To unsubscribe from this group, send email to
>>>>> >>>> > excel-macros...@googlegroups.com.
>>>>> >>>> > Visit this group at
>>>>> >>>> > http://groups.google.com/group/excel-macros?hl=en.
>>>>> >>>> >
>>>>> >>>> >
>>>>> >>>>
>>>>> >>>>
>>>>> >>>>
>>>>> >>>> --
>>>>> >>>> Regards, Jayaprakash. S (JAYAPRAKASH. S.) Adaptability is the most
>>>>> >>>> desirable habit for success - Swamy Vivekananda. This message is
>>>>> >>>> for
>>>>> >>>> the designated recipient only and may contain privileged,
>>>>> >>>> proprietary,
>>>>> >>>> or otherwise private information. If you have received it in
>>>>> >>>> error,
>>>>> >>>> please notify the sender immediately and delete the original. Any
>>>>> >>>> other
>>>>> >>>> use of the email by you is prohibited.
>>>>> >
>>>>> > --
>>>>> > Join official facebook page of this forum @
>>>>> > https://www.facebook.com/discussexcel
>>>>> >
>>>>> > FORUM RULES (1120+ members already BANNED for violation)
>>>>> >
>>>>> > 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>> > Please
>>>>> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>> > Advice will
>>>>> > not get quick attention or may not be answered.
>>>>> >
>>>>> > 2) Don't post a question in the thread of another member.
>>>>> >
>>>>> > 3) Don't post questions regarding breaking or bypassing any security
>>>>> > measure.
>>>>> >
>>>>> > 4) Acknowledge the responses you receive, good or bad.
>>>>> >
>>>>> > 5) Cross-promotion of, or links to, forums competitive to this forum
>>>>> > in
>>>>> > signatures are prohibited.
>>>>> >
>>>>> > 6) Jobs posting is not allowed.
>>>>> >
>>>>> > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
>>>>> > allowed.
>>>>> >
>>>>> > NOTE : Don't ever post personal or confidential data in a workbook.
>>>>> > Forum
>>>>> > owners and members are not responsible for any loss.
>>>>> > ---
>>>>> > You received this message because you are subscribed to the Google
>>>>> > Groups
>>>>> > "MS EXCEL AND VBA MACROS" group.
>>>>> > To post to this group, send email to excel-...@googlegroups.com.
>>>>> > To unsubscribe from this group, send email to
>>>>> > excel-macros...@googlegroups.com.
>>>>> > Visit this group at
>>>>> > http://groups.google.com/group/excel-macros?hl=en.
>>>>> >
>>>>> >
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Regards, Jayaprakash. S (JAYAPRAKASH. S.) Adaptability is the most
>>>>> desirable habit for success - Swamy Vivekananda. This message is for
>>>>> the designated recipient only and may contain privileged, proprietary,
>>>>> or otherwise private information. If you have received it in error,
>>>>> please notify the sender immediately and delete the original. Any other
>>>>> use of the email by you is prohibited.
>>>
>>> --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
>>> not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>>> owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google Groups
>>> "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>
>>>
>>
>>
>>
>>
>> --
>>
>> Thanks&Regards
>>
>> Veerendra.Vanam
>>
>> TOC TEAM
>> Bhagyanagar Electrical & Contractors
>> H.No-5-9-286/65,Plot No-65
>> Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukatpally,
>> Hyderabad-500072,-Andhra Pradesh
>> +91-9177-444-840,
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
>> not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
--
Regards, Jayaprakash. S (JAYAPRAKASH. S.) Adaptability is the most
desirable habit for success - Swamy Vivekananda. This message is for
the designated recipient only and may contain privileged, proprietary,
or otherwise private information. If you have received it in error,
please notify the sender immediately and delete the original. Any other
use of the email by you is prohibited.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
