date:20121105

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect Urgent Help Required

2012-11-05 Thread bhanu prakash

Paul,

I know the Rules of the forum...I had using this forum fro almost from long
time..appreciate your efforts in writing lengthy mail on this..

That exam itself designed by me..and I am not taking any exam ( Wrong
prediction) ..think positively ...this will nt have any loss for any one

Finally you suggested plenty of names for password...its better you use it
urself and dont suggest to anyone, which is not necessary here..none of
them buy ur suggestions here...

Hope had clarified your doubts in your mind..finally the gud news is that I
am capable of writing a VBA code to extract the source code in the file and
I am able to open file and do modification in the current test..

Had posted this file in this forum to get speedy & positive
response.never thought ppl like dont know solution to issue and
diverting the things in different way( negative minded persons--- I will
really petty on your wife)...now your long philosophy is just waste of time
of many..


Reagdrs,Bhanu


On Mon, Nov 5, 2012 at 8:33 PM, Paul Schreiner wrote:

>   Notice Forum Rule #3?
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
>
> WE don't have any way of knowing if you own the code or are simply trying
> break into the code to determine some type of proprietary information
> (hacking)
> If you are attempting to perform some illegal activity (obtain proprietary
> information, etc.)
> then we would them become accomplices in your activity.
>
> From the looks of your file, it looks like someone's classwork, in which
> you are attempting
> to find the correct answers, instead of doing the work... (if so, tsk tsk).
>
> If this is truly "urgent", then there ARE companies out there (try
> Googling) that,
> for a fee, will attempt to circumvent the security of your file.
>
> These companies have their own procedures in place to protect them from
> the legal aspects of the service they provide. (hence the need for the
> "fee")
>
> We, however, have no such protection.
>
> If, indeed, this is YOUR file, and need to get at the VBA in order to
> grade the exams,
> then I would suggest trying the name of your dog, wife, girlfriend, or
> combination thereof.
> (that is, the name of your girlfriend's dog, not girlfriend's wife.. which
> would be disturbing)
>
> sorry, and good luck.
>
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
>  --
> *From:* bhanu prakash 
> *To:* excel-macros@googlegroups.com
> *Sent:* Sun, November 4, 2012 11:55:01 PM
> *Subject:* $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect **
> Urgent Help Required**
>
> Dear Team ,
>
> Need your help in Unprotecting the VBA ( macro ) sheet..Or please let me
> know how to do it..this is required little urgent..kindly help Had attached
> the sheet for refference ..thanks
>
> Regards
> Bhanu
>
>
> --
> 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 com

Re: $$Excel-Macros$$ how to enable macros in my system

2012-11-05 Thread NOORAIN ANSARI

Hi,

Please goto Excel Option-Macro Security and enable all macros
see screen shot.




On Tue, Nov 6, 2012 at 11:47 AM, DELIN FRANCIS wrote:

>
> Dear All,
>
> Good morning,
>
> Here i got a problem
> i cant work with macros in my system
> how can instal it again?/
>
> for exp
> if i open a file with macros it is showing some security warning enable
> macros
> and then enabled still it is not working.
>
> please help me about this prob...
>
>
> cheers
>
> Delin F
>
> --
> 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.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
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.

Fwd: $$Excel-Macros$$ how to enable macros in my system

2012-11-05 Thread veerendra vanam

hI

 go to file-options-trust center-trust center setting-macro setting-enable
macros..


On Tue, Nov 6, 2012 at 11:47 AM, DELIN FRANCIS wrote:

>
> Dear All,
>
> Good morning,
>
> Here i got a problem
> i cant work with macros in my system
> how can instal it again?/
>
> for exp
> if i open a file with macros it is showing some security warning enable
> macros
> and then enabled still it is not working.
>
> please help me about this prob...
>
>
> cheers
>
> Delin F
>
> --
> 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.

$$Excel-Macros$$ how to enable macros in my system

2012-11-05 Thread DELIN FRANCIS



Dear All,

Good morning,

Here i got a problem 

i cant work with macros in my system
how can instal it again?/

for exp
if i open a file with macros it is showing some security warning enable macros
and then enabled still it is not working.

please help me about this prob...


cheers 


Delin F

-- 
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.

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

2012-11-05 Thread Rohan Young

Congratulation Rajan


On Tue, Nov 6, 2012 at 11:28 AM, Rajesh Nair  wrote:

> Congrats Rajan
>
>
> On Tue, Nov 6, 2012 at 10:23 AM, Kuldeep Singh wrote:
>
>>
>> Hi,
>>
>> *Congratulations* Rajan Sir.
>>
>> Regards,
>> Kuldeep Singh
>> Back Office Executive (MIS)
>> Info Edge India Limited (naukri.com)
>> Phone.: +91-120-4763789, Extn.: 789
>> naukrikuld...@gmail.com || www.naukri.com
>> *Please* *Consider the environment. Please don't print this e-mail
>> unless you really need to.*
>>  *
>> *
>> On Tue, Nov 6, 2012 at 10:20 AM, Satendra kumar <
>> satendrakuma...@gmail.com> wrote:
>>
>>> *CONGRATULATION. *
>>>
>>>  On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain wrote:
>>>

 Dear members,

 Rajan Verma has been selected as 'Most Helpful Member' for the month of
 Oct'12. He has posted 66 posts in last month and helped forum members
 through his excel expertise.
 I truly appreciate his knowledge, consistency and commitment to the
 group.
 *
 Rajan, please find enclosed the award certificate in honor of your
 contribution. Congratulations and thanks for your contribution.
 *

 Thanks to Ashish, Paul, Manoj, Vabz, Pravin, Noorain and all other
 folks for helping excel enthusiasts voluntarily !!
 Keep posting.

 Regards,
 Ayush Jain
 Group Manager

 P.S. If you have any feedback, please share your thoughts by filling
 the survey 
 form.



 --
 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
>>> Satendra Kumar
>>>
>>> --
>>> 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, f

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

2012-11-05 Thread Rajesh Nair

Congrats Rajan

On Tue, Nov 6, 2012 at 10:23 AM, Kuldeep Singh wrote:

>
> Hi,
>
> *Congratulations* Rajan Sir.
>
> Regards,
> Kuldeep Singh
> Back Office Executive (MIS)
> Info Edge India Limited (naukri.com)
> Phone.: +91-120-4763789, Extn.: 789
> naukrikuld...@gmail.com || www.naukri.com
> *Please* *Consider the environment. Please don't print this e-mail unless
> you really need to.*
>  *
> *
> On Tue, Nov 6, 2012 at 10:20 AM, Satendra kumar  > wrote:
>
>> *CONGRATULATION. *
>>
>>  On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain wrote:
>>
>>>
>>> Dear members,
>>>
>>> Rajan Verma has been selected as 'Most Helpful Member' for the month of
>>> Oct'12. He has posted 66 posts in last month and helped forum members
>>> through his excel expertise.
>>> I truly appreciate his knowledge, consistency and commitment to the
>>> group.
>>> *
>>> Rajan, please find enclosed the award certificate in honor of your
>>> contribution. Congratulations and thanks for your contribution.
>>> *
>>>
>>> Thanks to Ashish, Paul, Manoj, Vabz, Pravin, Noorain and all other folks
>>> for helping excel enthusiasts voluntarily !!
>>> Keep posting.
>>>
>>> Regards,
>>> Ayush Jain
>>> Group Manager
>>>
>>> P.S. If you have any feedback, please share your thoughts by filling the 
>>> survey
>>> form.
>>>
>>>
>>>
>>> --
>>> 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
>> Satendra Kumar
>>
>> --
>> 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
>

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

2012-11-05 Thread Kuldeep Singh

Hi,

*Congratulations* Rajan Sir.

Regards,
Kuldeep Singh
Back Office Executive (MIS)
Info Edge India Limited (naukri.com)
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
*
*
On Tue, Nov 6, 2012 at 10:20 AM, Satendra kumar
wrote:

> *CONGRATULATION. *
>
> On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain  wrote:
>
>>
>> Dear members,
>>
>> Rajan Verma has been selected as 'Most Helpful Member' for the month of
>> Oct'12. He has posted 66 posts in last month and helped forum members
>> through his excel expertise.
>> I truly appreciate his knowledge, consistency and commitment to the group.
>> *
>> Rajan, please find enclosed the award certificate in honor of your
>> contribution. Congratulations and thanks for your contribution.
>> *
>>
>> Thanks to Ashish, Paul, Manoj, Vabz, Pravin, Noorain and all other folks
>> for helping excel enthusiasts voluntarily !!
>> Keep posting.
>>
>> Regards,
>> Ayush Jain
>> Group Manager
>>
>> P.S. If you have any feedback, please share your thoughts by filling the 
>> survey
>> form.
>>
>>
>>
>>  --
>> 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
> Satendra Kumar
>
>  --
> 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

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

2012-11-05 Thread Satendra kumar

*CONGRATULATION. *

On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain  wrote:

>
> Dear members,
>
> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> Oct'12. He has posted 66 posts in last month and helped forum members
> through his excel expertise.
> I truly appreciate his knowledge, consistency and commitment to the group.
> *
> Rajan, please find enclosed the award certificate in honor of your
> contribution. Congratulations and thanks for your contribution.
> *
>
> Thanks to Ashish, Paul, Manoj, Vabz, Pravin, Noorain and all other folks
> for helping excel enthusiasts voluntarily !!
> Keep posting.
>
> Regards,
> Ayush Jain
> Group Manager
>
> P.S. If you have any feedback, please share your thoughts by filling the 
> survey
> form.
>
>
>
>  --
> 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
Satendra Kumar

-- 
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.

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

2012-11-05 Thread अनिल नारायण गवली

Dear Rajan,

Congrats Dear..keep going...
Cheers.



Regards
Gawli Anil

On Tue, Nov 6, 2012 at 9:58 AM,  wrote:

> **
> Congratulations ... Great going!!!
> Sent on my BlackBerry® from Vodafone
> --
> *From: * Ayush Jain 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Mon, 5 Nov 2012 22:57:57 +0530
> *To: *excel-macros
> *ReplyTo: * excel-macros@googlegroups.com
> *Cc: *rajanverma1...@gmail.com
> *Subject: *$$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12
>
>
> Dear members,
>
> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> Oct'12. He has posted 66 posts in last month and helped forum members
> through his excel expertise.
> I truly appreciate his knowledge, consistency and commitment to the group.
> *
> Rajan, please find enclosed the award certificate in honor of your
> contribution. Congratulations and thanks for your contribution.
> *
>
> Thanks to Ashish, Paul, Manoj, Vabz, Pravin, Noorain and all other folks
> for helping excel enthusiasts voluntarily !!
> Keep posting.
>
> Regards,
> Ayush Jain
> Group Manager
>
> P.S. If you have any feedback, please share your thoughts by filling the 
> survey
> form.
>
>
>
>  --
> 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.
>
>
>



-- 
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd

-- 
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

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

2012-11-05 Thread vba

Congratulations ... Great going!!!

Sent on my BlackBerry® from Vodafone

-Original Message-
From: Ayush Jain 
Sender: excel-macros@googlegroups.com
Date: Mon, 5 Nov 2012 22:57:57 
To: excel-macros
Reply-To: excel-macros@googlegroups.com
Cc: rajanverma1...@gmail.com
Subject: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

Dear members,

Rajan Verma has been selected as 'Most Helpful Member' for the month of
Oct'12. He has posted 66 posts in last month and helped forum members
through his excel expertise.
I truly appreciate his knowledge, consistency and commitment to the group.
*
Rajan, please find enclosed the award certificate in honor of your
contribution. Congratulations and thanks for your contribution.
*

Thanks to Ashish, Paul, Manoj, Vabz, Pravin, Noorain and all other folks
for helping excel enthusiasts voluntarily !!
Keep posting.

Regards,
Ayush Jain
Group Manager

P.S. If you have any feedback, please share your thoughts by filling the survey
form.

-- 
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.

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

2012-11-05 Thread Aamir Shahzad

Congrats Rajan

On Mon, Nov 5, 2012 at 10:29 PM, veerendra vanam
wrote:

> Congrats,
>
>
> On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain  wrote:
>
>>
>> Dear members,
>>
>> Rajan Verma has been selected as 'Most Helpful Member' for the month of
>> Oct'12. He has posted 66 posts in last month and helped forum members
>> through his excel expertise.
>> I truly appreciate his knowledge, consistency and commitment to the group.
>> *
>> Rajan, please find enclosed the award certificate in honor of your
>> contribution. Congratulations and thanks for your contribution.
>> *
>>
>> Thanks to Ashish, Paul, Manoj, Vabz, Pravin, Noorain and all other folks
>> for helping excel enthusiasts voluntarily !!
>> Keep posting.
>>
>> Regards,
>> Ayush Jain
>> Group Manager
>>
>> P.S. If you have any feedback, please share your thoughts by filling the 
>> survey
>> form.
>>
>>
>>
>> --
>> 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.
>
>
>



-- 

Regards,
Aamir Shahzad

-- 
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 em

$$Excel-Macros$$ Re: To Convert 1XL into MANY FILE XL Files

2012-11-05 Thread Rajan_Verma

you will get what you want here ..

http://excelpoweruser.wordpress.com/2012/05/03/split-data-into-multiple-workbook/

Thanks
Rajan verma

On Tuesday, 6 November 2012 08:30:08 UTC+5:30, Somnath Khadilkar wrote:
>
> On 11/4/12, Somnath Khadilkar > wrote: 
> > Dear SIrs, 
> >I have an XL file with few sheets [ DATANov01] 
> > One of the sheets contain general info named -common info 
> >  . 
> >One sheet named DATA has 5col. 
> >   I need to generate as many files from this single file as many are 
> >   -unique values of the col. B[Circle]. 
> > 
> >The new files so generated must have names which are generatd with 
> > the uniq values 
> > obtained [ eg MUMBAINov01, BENGALNov01 etc. ] 
> > 
> > The split files DATA must have all the col of DATA sheets A thru E 
> except B 
> > The split files must have ALL rows containing the uniq col in the sheet 
> > say MUMBAI has only MUMBAI realated rows [ w/o colm B, now redundant.] 
> > 
> > All other sheets  of the file must stay unchanged. 
> > 
> > Cheers 
> > 
> > -- 
> > 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-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.

$$Excel-Macros$$ Re: Rajan Verma - Most Helpful Member October'12

2012-11-05 Thread Prince

Congrats Excel Guru.

Regards
Prince dubey.

On Monday, 5 November 2012 22:58:39 UTC+5:30, Ayush Jain wrote:
>
>
> Dear members,
>  
> Rajan Verma has been selected as 'Most Helpful Member' for the month of 
> Oct'12. He has posted 66 posts in last month and helped forum members 
> through his excel expertise.
> I truly appreciate his knowledge, consistency and commitment to the group.
> *
> Rajan, please find enclosed the award certificate in honor of your 
> contribution. Congratulations and thanks for your contribution.
> *
>
> Thanks to Ashish, Paul, Manoj, Vabz, Pravin, Noorain and all other folks 
> for helping excel enthusiasts voluntarily !! 
> Keep posting.
>  
> Regards,
> Ayush Jain
> Group Manager
>
> P.S. If you have any feedback, please share your thoughts by filling the 
> survey 
> form.
>  
>
>
>
>

-- 
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.

Re: $$Excel-Macros$$ vba to loop through the visible cells.

2012-11-05 Thread t vinay

thank you all for all your help...

Regards,
Vinay

On 4 November 2012 14:44, ashish koul  wrote:

> Sub loop_visible_cells_only()
> Dim vsblrng As Range, cell As Range
> Set vsblrng = Sheets(1).Range("a1:a50").SpecialCells(xlCellTypeVisible)
> For Each cell In vsblrng.Cells
> 'MsgBox cell.Address(0, 0) Your code
> Next
> End Sub
>
>
>
> On Fri, Nov 2, 2012 at 8:12 PM, Rajan_Verma wrote:
>
>> *For each cell in
>> Range(“A1”).CurrentRegion.SpecialCells(xlcelltypevisible)*
>>
>> *‘Your code here*
>>
>> *next*
>>
>> * *
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>> * *
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *t vinay
>> *Sent:* 02 November 2012 8:11
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ vba to loop through the visible cells.
>>
>> ** **
>>
>> Hi Team,
>>
>> ** **
>>
>> Can you help with the vba code to loop through the each(visible) cell of
>> the filtered data in a sheet.
>>
>> ** **
>>
>> Thanks for your help!
>> 
>>
>> ** **
>>
>> -- 
>>
>> Regards,
>>
>>  
>>
>> Vinay. T
>>
>> ** **
>>
>> --
>> 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*
> * *
> *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 G

Re: $$Excel-Macros$$ Organization Chart

2012-11-05 Thread ANKUR AGGARWAL

Can somebody please help on the same ?

 
Warm Regards
Ankur Aggarwal
91-8010614628
Analyst
Mckinsey Knowledge Center
Mckinsey & Co.



 From: ANKUR AGGARWAL 
To: "noorain.ans...@gmail.com" ; 
"excel-macros@googlegroups.com"  
Sent: Monday, 5 November 2012 6:31 PM
Subject: $$Excel-Macros$$ Organization Chart
 

Hi team,

Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the 
sample excel file, in Sheet 1 there is an attached Organization chart which I 
am creating through VBA code., I want to fill each node of the chart 
dynamically through VBA, but the problem is I am not able to access nodes of 
the organization chart through code. 

Its taking whole organization chart as a shape and not able to access node of 
the organization chart.

Can somebody please help me out. Its very urgent as I have to complete 
something by EOD. 
 
Thanks in advance.
 
Warm Regards
Ankur Aggarwal
Analyst


-- 
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.

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

2012-11-05 Thread veerendra vanam

dear sir i need send attachment also pls send vba code for attachment,,


On Mon, Nov 5, 2012 at 10:49 PM,  wrote:

> **
> Right now its manual effort . You need to click on button every hour
> Sent on my BlackBerry® from Vodafone
> --
> *From: * veerendra vanam 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Mon, 5 Nov 2012 22:50:04 +0530
> *To: *
> *ReplyTo: * excel-macros@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 hrplz tell me,,
>
>
> On Mon, Nov 5, 2012 at 10:43 PM, ashish koul wrote:
>
>> check the attachment see if it helps
>>
>>
>> On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam <
>> veerendra.va...@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-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*
>> * *
>> *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-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

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

2012-11-05 Thread Paul Schreiner

If you have the macro able to run by a button,
check the documentation for the OnTime function.

this should allow you to set it up to run at specific times.


 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: veerendra vanam 
To: excel-macros@googlegroups.com
Sent: Mon, November 5, 2012 12:25:26 PM
Subject: Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

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,  wrote:

Right now its manual effort . You need to click on button every hour
>
>Sent on my BlackBerry® from Vodafone


>From: veerendra vanam  
>Sender: excel-macros@googlegroups.com 
>Date: Mon, 5 Nov 2012 22:50:04 +0530
>To: 
>ReplyTo: excel-macros@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 hrplz tell me,, 
>
>
>
>
>On Mon, Nov 5, 2012 at 10:43 PM, ashish koul  wrote:
>
>check the attachment see if it helps  
>>
>>
>>
>>On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam  
>>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-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
>> 
>>Ashish Koul
>>
>>
>>
>>
>>Visit
>>http://www.excelvbamacros.com/
>>http://www.accessvbamacros.com/
>>
>>
>>PBefore 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-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
>

Re: $$Excel-Macros$$ Calculate years and months between today daye and given date

2012-11-05 Thread Paul Schreiner

You know, I've used DateDIFF in VBA, and I THOUGHT there used to be an Excel 
equivalent.
but when I looked in Excel2010, I didn't find it in the function wizard.

Now it looks like it's THERE, but undocumented.

You can find it in ONLINE help, but not in the help file in Excel.

---

it's kind-of odd though.

it does some truncating.

the difference between
9/5/2010 and 11/5/2012 is 2 years, 2 months
but the difference between
9/6/2010 and 11/5/2012 is 2 years 1 month.

That's because it says the difference is:
9/5/2010 and 11/5/2012
2 Years , 2 Months and 0 days
and
9/6/2010 and 11/5/2012
2 Years , 1 Months and 30 days

it works, but you really need to be careful when doing this kind of date 
calculation.

Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-

From: Ms Excel user 
To: excel-macros@googlegroups.com
Sent: Mon, November 5, 2012 12:17:10 PM
Subject: Re: $$Excel-Macros$$ Calculate years and months between today daye and 
given date

Hi,

 use this  =DATEDIF(A2,TODAY(),"y")&" Years "& "and 
"&DATEDIF(A2,TODAY(),"ym")&" Months"

-- 

Best Regards, 
Ms Excel User
On Mon, Nov 5, 2012 at 5:11 PM, excel lerner  wrote:

Hello sir
>
>Can you please explain how to get completd years ,Months bet ween
>todays date and pevius year date.example
>
>01/04/1954
>05/11/2012
>
>please tell me the formula
>thanq sir
>
>--
>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.

-- 
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 res

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

2012-11-05 Thread veerendra vanam

Congrats,

On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain  wrote:

>
> Dear members,
>
> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> Oct'12. He has posted 66 posts in last month and helped forum members
> through his excel expertise.
> I truly appreciate his knowledge, consistency and commitment to the group.
> *
> Rajan, please find enclosed the award certificate in honor of your
> contribution. Congratulations and thanks for your contribution.
> *
>
> Thanks to Ashish, Paul, Manoj, Vabz, Pravin, Noorain and all other folks
> for helping excel enthusiasts voluntarily !!
> Keep posting.
>
> Regards,
> Ayush Jain
> Group Manager
>
> P.S. If you have any feedback, please share your thoughts by filling the 
> survey
> form.
>
>
>
>  --
> 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.

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

2012-11-05 Thread veerendra vanam

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,  wrote:

> **
> Right now its manual effort . You need to click on button every hour
> Sent on my BlackBerry® from Vodafone
> --
> *From: * veerendra vanam 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Mon, 5 Nov 2012 22:50:04 +0530
> *To: *
> *ReplyTo: * excel-macros@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 hrplz tell me,,
>
>
> On Mon, Nov 5, 2012 at 10:43 PM, ashish koul wrote:
>
>> check the attachment see if it helps
>>
>>
>> On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam <
>> veerendra.va...@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-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*
>> * *
>> *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-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.
>

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

2012-11-05 Thread koul . ashish

Right now its manual effort . You need to click on button every hour

Sent on my BlackBerry® from Vodafone

-Original Message-
From: veerendra vanam 
Sender: excel-macros@googlegroups.com
Date: Mon, 5 Nov 2012 22:50:04 
To: 
Reply-To: excel-macros@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 hrplz tell me,,


On Mon, Nov 5, 2012 at 10:43 PM, ashish koul  wrote:

> check the attachment see if it helps
>
>
> On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam <
> veerendra.va...@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-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*
> * *
> *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-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/

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

2012-11-05 Thread veerendra vanam

Thanks for reply in this code when i am run the macro every 1 hr send
automatically or we click the button every 1 hrplz tell me,,


On Mon, Nov 5, 2012 at 10:43 PM, ashish koul  wrote:

> check the attachment see if it helps
>
>
> On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam <
> veerendra.va...@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-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*
> * *
> *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-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@google

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

2012-11-05 Thread ashish koul

check the attachment see if it helps

On Mon, Nov 5, 2012 at 10:27 PM, veerendra vanam
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-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*
* *
*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-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.




send email.xlsm
Description: Binary data

$$Excel-Macros$$ Send mail from outlook Every One Hr .

2012-11-05 Thread veerendra vanam

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-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.




Update data.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ HELP REQUIRED FOR me

2012-11-05 Thread Paul Schreiner

Have you noticed Forum Rule #1?

---
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.
---

I'm sure that there are many people out there that will be more than happy to 
help you.
Just as I am sure that there is bound to be several people that know exactly 
what you need and can help you quickly.

But... EVERYONE that posts a new question here "requires help".

There's a good possibility that half of the people that COULD help choose not 
to 

simply because they don't feel that you are willing to even follow basic 
guidelines 

that are designed to help US help YOU.

Which, sometimes doesn't make much sense that I would spend this many 
keystrokes 
offering CONSTRUCTIVE criticism, instead of simply helping with the problem...

But please, do yourself a favor and use a Subject line that will allow a person 
with the expertise that can solve your problem to recognize where his/her 
assistance is needed.

 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: Somnath Khadilkar 
To: excel-macros@googlegroups.com
Sent: Sun, November 4, 2012 9:10:28 AM
Subject: $$Excel-Macros$$ HELP REQUIRED FOR me

Dear SIrs,
  I have an XL file with few sheets [ DATANov01]
One of the sheets contain general info named -common info
.
  One sheet named DATA has 5col.
  I need to generate as many files from this single file as many are
  -unique values of the col. B[Circle].

  The new files so generated must have names which are generatd with
the uniq values
obtained [ eg MUMBAINov01, BENGALNov01 etc. ]

The split files DATA must have all the col of DATA sheets A thru E except B
The split files must have ALL rows containing the uniq col in the sheet
say MUMBAI has only MUMBAI realated rows [ w/o colm B, now redundant.]

All other sheets  of the file must stay unchanged.

Cheers

-- 
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.

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect Urgent Help Required

2012-11-05 Thread Paul Schreiner

Notice Forum Rule #3?

3) Don't post questions regarding breaking or bypassing any security measure.

 
WE don't have any way of knowing if you own the code or are simply trying break 
into the code to determine some type of proprietary information (hacking)
If you are attempting to perform some illegal activity (obtain proprietary 
information, etc.)
then we would them become accomplices in your activity.

>From the looks of your file, it looks like someone's classwork, in which you 
>are 
attempting
to find the correct answers, instead of doing the work... (if so, tsk tsk).

If this is truly "urgent", then there ARE companies out there (try Googling) 
that,
for a fee, will attempt to circumvent the security of your file.

These companies have their own procedures in place to protect them from 
the legal aspects of the service they provide. (hence the need for the "fee")

We, however, have no such protection.

If, indeed, this is YOUR file, and need to get at the VBA in order to grade the 
exams, 

then I would suggest trying the name of your dog, wife, girlfriend, or 
combination thereof.
(that is, the name of your girlfriend's dog, not girlfriend's wife.. which 
would 
be disturbing)
 
sorry, and good luck.

Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: bhanu prakash 
To: excel-macros@googlegroups.com
Sent: Sun, November 4, 2012 11:55:01 PM
Subject: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help 
Required**


Dear Team ,

Need your help in Unprotecting the VBA ( macro ) sheet..Or please let me know 
how to do it..this is required little urgent..kindly help Had attached the 
sheet 
for refference ..thanks

Regards
Bhanu
-- 
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.

Re: $$Excel-Macros$$ iterative / sequential find and replace

2012-11-05 Thread Paul Schreiner

I'm not quite sure what you mean by using find/replace.
I realize you want to replace "1a" with "2", but perhaps there's more to it 
than 
that.

I'm not sure if you're looking for a VBA solution, or a Excel "menu" solution?

Is the data sorted? or are you intending to perform this replacement to ENABLE 
a 
sort?

We could easily split the line using the "." as a delimeter,
load the lines into an array.
sort the array,
output the array, using the array index instead of the first element (1a,1b, 
etc.)

But, before I spend a whole bunch of time developing a wild approach to a 
problem that turns
out to be nothing like what I thought I was dealing with,
perhaps I need some more information, and perhaps a larger sample of data...
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: Paul 
To: excel-macros@googlegroups.com
Sent: Mon, November 5, 2012 5:05:03 AM
Subject: $$Excel-Macros$$ iterative / sequential find and replace

Hi,
I frequently have lists, each entry of the list is a one-sentence paragraph 
ending in a full-stop (period), and is prefixed by a non-sequential number or 
letter or combination, followed by a full-stop and then a tab. So, it might 
look 
like this (tabs are shown as arrows, for clarity):

1.→People like to help in online forums.
1a.→Hopefully they will be able to help this time.
x.→I'll be a little stuck without some help with this.

The reason that the prefix is non-sequential and unpredictable is that the 
order 
of the list is shuffled about a lot during editing, and for reasons I can't 
explain here, I cannot use MS Word's autonumbering feature. Once the list has 
been finalized, I have to renumber the entries sequentially:

1.→People like to help in online forums.
2.→Hopefully they will be able to help this time.
3.→I'll be a little stuck without some help with this.

Can anyone suggest how to do this? The lists are consistent enough that I think 
it should be possible to "find" "^p*.^t", but (assuming this is correct), I 
don't know how to get the "replace" bit to work the way I want. Any help would 
be most appreciated!
Thanks,
Paul



-- 
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.

Re: $$Excel-Macros$$ How to delete alternate sheets faster

2012-11-05 Thread Paul Schreiner

Sorry, this has nothing to do with deleting alternate sheets.
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: ANKUR AGGARWAL 
To: "excel-macros@googlegroups.com" 
Cc: "noorain.ans...@gmail.com" 
Sent: Mon, November 5, 2012 6:33:01 AM
Subject: Re: $$Excel-Macros$$ How to delete alternate sheets faster


Hi team,

Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the 
sample excel file, in Sheet 1 there is an attached Organization chart which I 
am 
creating through VBA code., I want to fill each node of the chart dynamically 
through VBA, but the problem is I am not able to access nodes of the 
organization chart through code. 

Its taking whole organization chart as a shape and not able to access node of 
the organization chart.

Can somebody please help me out. Its very urgent as I have to complete 
something 
by EOD. 

Thanks in advance.

Warm Regards
Ankur Aggarwal
91-8010614628
Analyst
Mckinsey Knowledge Center
Mckinsey & Co.



From: NOORAIN ANSARI 
To: excel-macros@googlegroups.com 
Sent: Thursday, 1 November 2012 11:53 AM
Subject: Re: $$Excel-Macros$$ How to delete alternate sheets faster


Dear Pravin,

Please press Alt+F11 and goto Insert-module and paste code
and press F5 to execute macro.

Hope it will useful for you.




On Thu, Nov 1, 2012 at 11:40 AM, Pravin Gunjal  wrote:

Dear Noorain 
>
>
>Pl inform how to and where to use this code..
>Thank you.
>
>Pravin.
>
>
>
>
>On Thu, Nov 1, 2012 at 11:04 AM, NOORAIN ANSARI  
>wrote:
>
>Dear Pravin,
>>
>>
>>Please try
>>
>>Sub delete_alternative_sheet()
>>Dim i As Integer
>>On Error Resume Next
>>For i = 2 To Sheets.Count Step 2
>>Sheets(i).Delete
>>Next i
>>End Sub 
>>
>>
>>
>>On Thu, Nov 1, 2012 at 10:51 AM, Pravin Gunjal  wrote:
>>
>>Dear Friends, 
>>>
>>>
>>>Greetings !
>>>
>>>
>>>I am having an excel file (office 2007) containing 43 sheets in it and would 
>>>like to delete alternative sheets like 2-4-6 etc. up to the end.
>>>
>>>
>>>Is it possible to select all those sheets at a time and delete the same. As 
>>>currently I am selecting one by one and deleting all of them.
>>>
>>>
>>>Thank you,
>>>
>>>
>>>Regards
>>>Pravin Gunjal.
>>>
>>>-- 
>>>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.
>>> 
>>> 
>>>
>>
>>
>>-- 
>>With Regards,
>>Noorain Ansari
>>http://noorainansari.com
>>http://excelvbaclinic.com 
>>
>>
>>
>>-- 
>>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"

Re: $$Excel-Macros$$ Calculate years and months between today daye and given date

2012-11-05 Thread Paul Schreiner

You've asked for the FORMULA,
That implies that you don't want to use VBA, but wish to use Excel formulas.

Let's say that the date you're checking is in A2,

The simple answer is to subtract this year "Year(Today())"
>From the year of the of the date in A2 "Year(A2)"
giving:
YEAR(TODAY())-YEAR(A2)
The month calculation is similar:
MONTH(TODAY()) - MONTH(A2)

However, if the month happens to be AFTER the current month

For instance, checking December 12, 1954
Then the month calculation becomes negative.
In which case, you would need to subtract (1) from the year result,
and subtract this month difference from 12.

So, I'd say that the first thing you must do is check to see
if the month value of the date in question is after the current month,
then modify your formula accordingly:

=IF(MONTH(TODAY()) < MONTH(A2),
YEAR(TODAY())-YEAR(A2) - 1 &" years, " & 12+MONTH(TODAY()) - MONTH(A2) & " 
months",
YEAR(TODAY())-YEAR(A2) &" years, " & MONTH(TODAY()) - MONTH(A2) & " months")
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: excel lerner 
To: excel-macros@googlegroups.com
Sent: Mon, November 5, 2012 6:42:06 AM
Subject: $$Excel-Macros$$ Calculate years and months between today daye and 
given date

Hello sir

Can you please explain how to get completd years ,Months bet ween
todays date and pevius year date.example

01/04/1954
05/11/2012

please tell me the formula
thanq sir

-- 
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.

$$Excel-Macros$$ Organization Chart

2012-11-05 Thread ANKUR AGGARWAL

Hi team,

Can anyone help me in Shape - Organizational chart in MS Excel. Attached is the 
sample excel file, in Sheet 1 there is an attached Organization chart which I 
am creating through VBA code., I want to fill each node of the chart 
dynamically through VBA, but the problem is I am not able to access nodes of 
the organization chart through code. 

Its taking whole organization chart as a shape and not able to access node of 
the organization chart.

Can somebody please help me out. Its very urgent as I have to complete 
something by EOD. 
 
Thanks in advance.
 
Warm Regards
Ankur Aggarwal
Analyst

-- 
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.




Example.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Calculate years and months between today daye and given date

2012-11-05 Thread Aamir Shahzad

 You can use the following formula

=YEAR(D4)-YEAR(D3)&" Years"&" "&MONTH(D4)-MONTH(D3)&" Months"

Aamir Shahzad

On Mon, Nov 5, 2012 at 4:51 PM, Kuldeep Singh wrote:

>
> Hi,
>
> You can use *DATEDIF()* formula.
>
> Regards,
> Kuldeep Singh
>
>
> On Mon, Nov 5, 2012 at 5:11 PM, excel lerner wrote:
>
>> Hello sir
>>
>> Can you please explain how to get completd years ,Months bet ween
>> todays date and pevius year date.example
>>
>> 01/04/1954
>> 05/11/2012
>>
>> please tell me the formula
>> thanq sir
>>
>> --
>> 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,
Aamir Shahzad

-- 
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.

Re: $$Excel-Macros$$ Calculate years and months between today daye and given date

2012-11-05 Thread Kuldeep Singh

Hi,

You can use *DATEDIF()* formula.

Regards,
Kuldeep Singh

On Mon, Nov 5, 2012 at 5:11 PM, excel lerner  wrote:

> Hello sir
>
> Can you please explain how to get completd years ,Months bet ween
> todays date and pevius year date.example
>
> 01/04/1954
> 05/11/2012
>
> please tell me the formula
> thanq sir
>
> --
> 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.

$$Excel-Macros$$ Calculate years and months between today daye and given date

2012-11-05 Thread excel lerner

Hello sir

Can you please explain how to get completd years ,Months bet ween
todays date and pevius year date.example

01/04/1954
05/11/2012

please tell me the formula
thanq sir

-- 
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.

$$Excel-Macros$$ iterative / sequential find and replace

2012-11-05 Thread Paul

Hi,
I frequently have lists, each entry of the list is a one-sentence paragraph 
ending in a full-stop (period), and is prefixed by a non-sequential number 
or letter or combination, followed by a full-stop and then a tab. So, it 
might look like this (tabs are shown as arrows, for clarity):

1.→People like to help in online forums.
1a.→Hopefully they will be able to help this time.
x.→I'll be a little stuck without some help with this.

The reason that the prefix is non-sequential and unpredictable is that the 
order of the list is shuffled about a lot during editing, and for reasons I 
can't explain here, I cannot use MS Word's autonumbering feature. Once the 
list has been finalized, I have to renumber the entries sequentially:

1.→People like to help in online forums.
2.→Hopefully they will be able to help this time.
3.→I'll be a little stuck without some help with this.

Can anyone suggest how to do this? The lists are consistent enough that I 
think it should be possible to "find" "^p*.^t", but (assuming this is 
correct), I don't know how to get the "replace" bit to work the way I want. 
Any help would be most appreciated!
Thanks,
Paul



-- 
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.

Fwd: $$Excel-Macros$$ Can cursor will go to cell "D1" when we press enter

2012-11-05 Thread Pravin Gunjal

*Yesit's working fine...  This is what I wanted.*
*Thanks a lot !   Raja*
*
*
*Regards*
*Pravin Gunjal.
*
-- Forwarded message --
From: RAJA SEKAR 
Date: Sat, Nov 3, 2012 at 10:03 PM
Subject: Re: $$Excel-Macros$$ Can cursor will go to cell "D1" when we press
enter
To: excel-macros@googlegroups.com





On 3 November 2012 15:44, Pravin Gunjal  wrote:

> *Thanks Kuldeep for your reply.*
> *I want the cursor should go in the cell "D1" when the ENTER key is
> pressed.*
>  *
> *
> On Sat, Nov 3, 2012 at 3:35 PM, Kuldeep Singh wrote:
>
>>
>> Hi Pravin,
>>
>> You want to press enter --> D1,D2,D3 OR, D1,E1,F1,G1
>>
>> Regads,
>> Kuldeep Singh
>>
>> On Sat, Nov 3, 2012 at 3:32 PM, Pravin Gunjal  wrote:
>>
>>> *Dear Friends,*
>>> *
>>> *
>>> *Is it possible to move the cursor automatically in to the cell "D1"
>>> when we hit the ENTER key.*
>>> *Please inform.. Thank you.*
>>> *
>>> *
>>> *Regards*
>>> *Pravin Gunjal*
>>> *
>>> *
>>>
>>> --
>>> 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.
>>
>>
>>
>
>  --
> 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.
>
>
>



-- 
"Making a million friends is not a miracle, the miracle is to make a friend
who will stand by you when a million a

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect Urgent Help Required

Re: $$Excel-Macros$$ how to enable macros in my system

Fwd: $$Excel-Macros$$ how to enable macros in my system

$$Excel-Macros$$ how to enable macros in my system

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

$$Excel-Macros$$ Re: To Convert 1XL into MANY FILE XL Files

$$Excel-Macros$$ Re: Rajan Verma - Most Helpful Member October'12

Re: $$Excel-Macros$$ vba to loop through the visible cells.

Re: $$Excel-Macros$$ Organization Chart

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

Re: $$Excel-Macros$$ Calculate years and months between today daye and given date

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

Re: $$Excel-Macros$$ Send mail from outlook Every One Hr .

$$Excel-Macros$$ Send mail from outlook Every One Hr .

Re: $$Excel-Macros$$ HELP REQUIRED FOR me

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect Urgent Help Required

Re: $$Excel-Macros$$ iterative / sequential find and replace

Re: $$Excel-Macros$$ How to delete alternate sheets faster

Re: $$Excel-Macros$$ Calculate years and months between today daye and given date

$$Excel-Macros$$ Organization Chart

Re: $$Excel-Macros$$ Calculate years and months between today daye and given date

Re: $$Excel-Macros$$ Calculate years and months between today daye and given date

$$Excel-Macros$$ Calculate years and months between today daye and given date

$$Excel-Macros$$ iterative / sequential find and replace

Fwd: $$Excel-Macros$$ Can cursor will go to cell "D1" when we press enter

35 matches

Site Navigation

Mail list logo

Footer information