Re: $$Excel-Macros$$ Req VBA Code

[Veeru TOC]

Dear Nooran sir,


  thanks for Replay Ineed VBA Code for  Thsi Particular
sheet,,

On Wed, Jun 13, 2012 at 12:24 PM, NOORAIN ANSARI
wrote:

> Dear Veeru,
>
> See attachment, Hope it will help to you.
>
>
> On Wed, Jun 13, 2012 at 12:02 PM, Veeru TOC  wrote:
>
>>
>>
>>
>>> Dear Team
>>>
>>>
>>>   I attached Excel file Sheet1 -Names,Sheet-2 form ,
>>> when i click command button Create Particular Name with form
>>> --
>>>
>>>
>>>
>>>
>>>
>>> *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**,*
>>>
>>>
>>>  --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>> --
>>
>>
>>
>>
>>
>> *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**,*
>>
>>
>>  --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
>
>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 





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

-- 
FORUM RULES (986+ 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 bypas

Re: $$Excel-Macros$$ Req VBA Code

[Veeru TOC]

> Dear Team
>
>
>   I attached Excel file Sheet1 -Names,Sheet-2 form , when
> i click command button Create Particular Name with form
> --
>
>
>
>
>
> *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**,*
>
>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 





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

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

Re: $$Excel-Macros$$ I want to learn macro from basic level

[LAKSHMAN PRASAD]

That's gud
 
 

Lakshman Prasad
Manager (Finance)
GAURSONS INDIA LIMITED 
Ph: +91 12 456777 Mob. No. 9582279261
Website: http://www.gaursonsindia.com/



From: Rajan_Verma 
To: excel-macros@googlegroups.com 
Sent: Tuesday, June 12, 2012 7:23 PM
Subject: RE: $$Excel-Macros$$ I want to learn macro from basic level


Hi  Guys
 
Download from this Link for excel 2007
 
http://www.comp.nus.edu.sg/~justin88/Excel%202007%20Power%20Programming%20With%20VBA.pdf
 
 
 
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
 
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Rakesh Kumar Sharma
Sent: 12 June 2012 7:04
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ I want to learn macro from basic level
 
Hi Rajan,

Plz send me on my email id    if possible


On Tue, Jun 12, 2012 at 6:15 PM, Rajan_Verma  wrote:
Excel Power programming with VBA J
 
Either you can download from internet its free or I will send you on your email 
id .. 
Really nice book to start from scratch.
 
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
 
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Rakesh Kumar Sharma
Sent: 12 June 2012 3:00
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ I want to learn macro from basic level
 
Hi Masters,

If you have any attachment which can help me to learn excel macro from starting 
point, plz share.


-- 
Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741
-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com



-- 
Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741


-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to 
excel-macros+unsubscr...@googlegroups.com-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post persona

Re: $$Excel-Macros$$ I want to learn macro from basic level

[LAKSHMAN PRASAD]

Dear Rajan and All,
 
I request,
 
Don’t say like this "I will send you on your email id ".If you really want to 
send then send him  silently.

 

Lakshman Prasad
Manager (Finance)
GAURSONS INDIA LIMITED 
Ph: +91 12 456777 Mob. No. 9582279261
Website: http://www.gaursonsindia.com/



From: "amar.gur...@gmail.com" 
To: excel-macros@googlegroups.com 
Sent: Tuesday, June 12, 2012 6:17 PM
Subject: Re: $$Excel-Macros$$ I want to learn macro from basic level


Hi Rajan,

Please send the same on my email I'd on amar.mas...@gmail.com

Regards,
Amar 
Sent on my BlackBerry® from Vodafone



From: "Rajan_Verma"  
Sender: excel-macros@googlegroups.com 
Date: Tue, 12 Jun 2012 18:15:14 +0530
To: 
ReplyTo: excel-macros@googlegroups.com 
Subject: RE: $$Excel-Macros$$ I want to learn macro from basic level

Excel Power programming with VBA J
 
Either you can download from internet its free or I will send you on your email 
id .. 
Really nice book to start from scratch.
 
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
 
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Rakesh Kumar Sharma
Sent: 12 June 2012 3:00
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ I want to learn macro from basic level
 
Hi Masters,

If you have any attachment which can help me to learn excel macro from starting 
point, plz share.


-- 
Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741


-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to 
excel-macros+unsubscr...@googlegroups.com-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com 
-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible 

Re: $$Excel-Macros$$ Sheet Requirements

[Deba Ranjan]

Thanks...


Thanks & Regards,
*Deba Ranjan P*





On Tue, Jun 12, 2012 at 9:43 PM, Mangesh Vimay wrote:

> Hi Dear,
>
> It happens with everybody specially when someone tries to learn new
> concepts of IT or any other topic. So keep going and this group is good to
> help you.
>
> MangeSH
>
> On Tue, Jun 12, 2012 at 6:45 PM, Deba Ranjan  wrote:
>
>> Thanks.
>>i love excel very much, Actually i keep on trying the coding But
>> really i am so sorry that i really don't have this Idea. i purchased books
>> for VBA macros and Excel, and i am trying my best to do so. Actually i am
>> very new to this concepts (Means VBA coding).  And even i am trying to
>> learn from this group as well.
>>   I adopted to learn one by one. Let me tell you honestly, i have no
>> system at my home. And what ever i learn, i learnt at Office but that too
>> also i have many few times to learnt myself. So its my drawback.
>>
>>  i hope i would able  very few things a day, Any way thanks for
>> suggesting that. i will keep trying. i have very confusion in coding when i
>> go trough the books. Like String, long etc.  
>>
>>
>> Thanks & Regards,
>> *Deba Ranjan P*
>>
>>
>> 
>>
>>
>> On Tue, Jun 12, 2012 at 6:34 PM, dguillett1  wrote:
>>
>>>   Forgive me but as I recall you have been a part of this group for
>>> awhile. If so, you should have learned enough to do this yourself.
>>>
>>> Don Guillett
>>> Microsoft MVP Excel
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* Deba Ranjan 
>>> *Sent:* Tuesday, June 12, 2012 6:45 AM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* $$Excel-Macros$$ Sheet Requirements
>>>
>>> Dear Experts,
>>>
>>> i have attached a file which contains many sheets. in every sheets
>>> there contains data. i want a button which on clicking the whole sheet data
>>> consolidated. Please find the attached.
>>>
>>> thanks...
>>>
>>>
>>> Thanks & Regards,
>>> *Deba Ranjan P*
>>>
>>>
>>> 
>>> --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>> --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>
>>  --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

[Dhartikumar Sahu]

Thanks Rajan


On Tue, Jun 12, 2012 at 6:11 PM, Rajan_Verma wrote:

> Hi dharti
>
> See the attached sheet.. I have used an class module to get application
> events , 
>
> ** **
>
> HTH
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *dhartiku...@gmail.com
> *Sent:* 12 June 2012 3:31
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ call addin fuction before activeworkbook
> close .. Urgent
>
> ** **
>
> Urgently required code please.
>
> Sent from BlackBerry® on Airtel
> --
>
> *From: *Dhartikumar Sahu  
>
> *Sender: *excel-macros@googlegroups.com 
>
> *Date: *Tue, 12 Jun 2012 10:46:34 +0530
>
> *To: *
>
> *ReplyTo: *excel-macros@googlegroups.com 
>
> *Subject: *$$Excel-Macros$$ call addin fuction before activeworkbook
> close .. Urgent
>
> ** **
>
> hi group
>
> ** **
>
> i want a vba code for call addin fuction before any workbook close.
>
> ** **
>
> please provide me code please..
> 
>
> ** **
>
> -- 
>
> *Regards,*
>
> *Dhartikumar Sahu*
>
> Sr.Database Manager - Institutional Equities
>
> * IDBI Capital Markets Services Ltd*
>
> 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21
>
> Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450***
> *
>
> ** **
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com 
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 

*Regards,*

*Dhartikumar Sahu*

Sr.Database Manager - Institutional Equities

* **IDBI Capital Markets Services Ltd*

5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21

Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450

-- 
FORUM RULES (986+ 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

Re: $$Excel-Macros$$ HELLO

[joseph . camill]

Hi,

I saw a similar thing on another block, wherein the guy warned in his next mail 
not to open the link and said it is a spam and has not been sent by him.

How can we protect our mail from such spam?

Thanks,
Joseph
Sent on my BlackBerry® from Vodafone

-Original Message-
From: NOORAIN ANSARI 
Sender: excel-macros@googlegroups.com
Date: Wed, 13 Jun 2012 08:32:21 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ HELLO

Dear Michael,

Please follow...

5)  Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.

-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

On Wed, Jun 13, 2012 at 4:46 AM, Michael Brumby wrote:

>
> this is intense you should check this out
> http://www.business15nanews.net/biz/?page=0655543
>
> --
> FORUM RULES (986+ 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.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ HELLO

[NOORAIN ANSARI]

Dear Michael,

Please follow...

5)  Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.

-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

On Wed, Jun 13, 2012 at 4:46 AM, Michael Brumby wrote:

>
> this is intense you should check this out
> http://www.business15nanews.net/biz/?page=0655543
>
> --
> FORUM RULES (986+ 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.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ HELLO

[Michael Brumby]

this is intense you should check this out 
http://www.business15nanews.net/biz/?page=0655543

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Date format change by running the macro

[dguillett1]

Fully tested on provided file.
The lr is the last populated row in column A and was based on the file 
presented. It is designed so that whatever cell you select in col A then column 
B ONLY to the lr will be filled with the formula and the formatting. If not, 
send your file personally to me...

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com

From: ankur 
Sent: Tuesday, June 12, 2012 11:22 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Date format change by running the macro

Thanks Don Sir
Very Nice Code

But it is not limited to  Selected Rangefull column is converted to desired 
format...
is there any way to limit the code upto selected range only

Regards:
CMA Ankur Pandey

 




On Tue, Jun 12, 2012 at 6:30 PM, dguillett1  wrote:

  Try

  Sub FormulaToEndOffset1SAS()
  Dim lr As Long
  With ActiveCell

  lr = Cells(.Row, .Column).End(xlDown).Row
  With Range(Cells(.Row, .Column + 1), Cells(lr, .Column + 1))
  .Formula = _
  "=IF(ISERR(DATE(LEFT(A" & .Row & ",4),MID(A" & .Row & ",5,2)," & _
  "RIGHT(A" & .Row & ",2))),,DATE(LEFT(A" & .Row & ",4), " & _
  "MID(A" & .Row & ",5,2),RIGHT(A" & .Row & ",2)))"
  .NumberFormat = "dd/mmm/"
  .Value = .Value
  End With

  End With
  End Sub
  ‘
  Don Guillett
  Microsoft MVP Excel
  SalesAid Software
  dguille...@gmail.com

  From: ankur 
  Sent: Tuesday, June 12, 2012 5:50 AM
  To: excel-macros@googlegroups.com 
  Subject: Re: $$Excel-Macros$$ Date format change by running the macro

  hi Experts
  i use this code to solve the query with slight modification,i want date 
format in adjacent cell..
  i used Macro for this..
  But problem is ,this code can run upto specific no. of row i.e 475
  i want to be it a dynamic ...i.e it should work with based on selection of 
range onlylike  solution of Krishna Sir is doing..what modification is 
needed in my codes

  File is attached for your reference
  thanks in advance


  Sub ChgMyFormat()

  ActiveCell.Offset(0, 1).Range("A1").Select
  ActiveCell.FormulaR1C1 = _
  
"=IF(ISERR(DATE(LEFT(RC[-1],4),MID(RC[-1],5,2),RIGHT(RC[-1],2))),,DATE(LEFT(RC[-1],4),MID(RC[-1],5,2),RIGHT(RC[-1],2)))"
  ActiveCell.Select
  Selection.AutoFill Destination:=ActiveCell.Range("A1:A475")
  ActiveCell.Range("A1:A475").Select
  ActiveCell.Columns("A:A").EntireColumn.Select
  Selection.Copy
  
  Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats
  Selection.NumberFormat = "dd/mmm/"
  ActiveCell.Columns("A:A").EntireColumn.EntireColumn.AutoFit
  ActiveCell.Offset(0, 1).Columns("A:A").EntireColumn.Select
  Application.CutCopyMode = False
  
  ActiveCell.Offset(0, -1).Range("A1").Select
  End Sub

  Regards:
  CMA Ankur Pandey

   




  On Tue, Jun 12, 2012 at 2:32 PM, Ashish Bhalara  
wrote:

Thank you Mr.Krish it is exactly what i want.


On Tue, Jun 12, 2012 at 2:21 PM, ankur  wrote:

  Hi Ahmed

  Sorry for this ...Now i had changed the settings.Thanks for 
correcting me..

  Regards:
  CMA Ankur Pandey

   




  On Tue, Jun 12, 2012 at 2:20 PM, ankur  wrote:

Hi Ahmed

Sorry for this ...Now i had changed the settings.Thanks for 
correcting me..


Regards:
CMA Ankur Pandey 


 




On Tue, Jun 12, 2012 at 2:11 PM, Ahmed Honest  
wrote:

  Dear Ankur,

  Please if you don't mind will you make your font sytle and size as a 
simple Or plain one. It looks too ODD.

  Thanks for your understanding.

  Regards,


  On Tue, Jun 12, 2012 at 11:38 AM, ankur  
wrote:

HI ASHISH
I TRIED THIS CODE FOR YOUR SOLUTION ,BUT IT IS NOT SO 
GOODbecause i dont know how to stop the code after the blank 
cellsExperts will guide me in this issue how to remove this flawfile is 
attached for your reference

Sub chgDateFormat()

ActiveCell.Offset(0, 1).Range("A1").Select
ActiveCell.FormulaR1C1 = _
"=DATE(LEFT(RC[-1],4),MID(RC[-1],5,2),RIGHT(RC[-1],2))"
ActiveCell.Select
Selection.AutoFill Destination:=ActiveCell.Range("A1:A500")
ActiveCell.Range("A1:A1").Select
End Sub




Regards:
CMA Ankur Pandey

 Visit My Site




On Tue, Jun 12, 2012 at 1:04 PM, Ashish Bhalara 
 wrote:

  Dear sir,

  I have data in which date written in 20120412 format and i want 
to make macro to which transfer the format to 12-Apr-2012 by running the macro 
on selection range. Please help me in my below code.

  Sub Macro1()
  Dim selct As Range
  selct = Range.Select
  Range = WorksheetFunction.TEXT(TEXT(selct, "-00-00"), 
"DD-MMM-")
  End Sub

  Thanks & regards. 

  

Re: $$Excel-Macros$$ I want to learn macro from basic level

[Mangesh Vimay]

Hi Gulzar,

As Rajan has mentioned in trail mail,
download the desired e-book from the link
http://www.comp.nus.edu.sg/~justin88/Excel%202007%20Power%20Programming%20With%20VBA.pdf




On Tue, Jun 12, 2012 at 9:50 PM, Gulzar Naqvi  wrote:

>
>
> Hi Mr. Rajan,
>
> Please also send Excel Power programming with VBA on my email I'd on
> sgna...@hotmail.com.
>
> Regards,
>
>
> GHNaqvi
>
>
> --
> Subject: Re: $$Excel-Macros$$ I want to learn macro from basic level
> To: excel-macros@googlegroups.com
> From: amar.gur...@gmail.com
> Date: Tue, 12 Jun 2012 12:47:10 +
>
>
> Hi Rajan,
>
> Please send the same on my email I'd on amar.mas...@gmail.com
>
> Regards,
> Amar
> Sent on my BlackBerry® from Vodafone
> --
> *From: * "Rajan_Verma" 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Tue, 12 Jun 2012 18:15:14 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *RE: $$Excel-Macros$$ I want to learn macro from basic level
>
> Excel Power programming with VBA J
>
>
>
> Either you can download from internet its free or I will send you on your
> email id ..
>
> Really nice book to start from scratch.
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Rakesh Kumar Sharma
> *Sent:* 12 June 2012 3:00
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ I want to learn macro from basic level
>
>
>
> Hi Masters,
>
> If you have any attachment which can help me to learn excel macro from
> starting point, plz share.
>
>
> --
> *Regards,
>
> **Rakesh Kumar Sharma**
> **Contact: +91-9971024741**
>
> *
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>  --
> FORUM RULES (986+ 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'

RE: $$Excel-Macros$$ I want to learn macro from basic level

[Gulzar Naqvi]

 Hi Mr. Rajan,
Please also send Excel Power programming with VBA on my email I'd on 
sgna...@hotmail.com. Regards,  GHNaqvi
 Subject: Re: $$Excel-Macros$$ I want to learn macro from basic level
To: excel-macros@googlegroups.com
From: amar.gur...@gmail.com
Date: Tue, 12 Jun 2012 12:47:10 +

Hi Rajan,

Please send the same on my email I'd on amar.mas...@gmail.com

Regards,
AmarSent on my BlackBerry® from VodafoneFrom:  "Rajan_Verma" 

Sender:  excel-macros@googlegroups.com
Date: Tue, 12 Jun 2012 18:15:14 +0530To: 
ReplyTo:  excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ I want to learn macro from basic level
Excel Power programming with VBA J Either you can download from internet its 
free or I will send you on your email id .. Really nice book to start from 
scratch. RegardsRajan verma+91 7838100659 [IM-Gtalk] From: 
excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf 
Of Rakesh Kumar Sharma
Sent: 12 June 2012 3:00
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ I want to learn macro from basic level Hi Masters,

If you have any attachment which can help me to learn excel macro from starting 
point, plz share.


-- 
Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com



-- 

FORUM RULES (986+ 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. 

 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

 

--

To post to this group, send email to excel-macros@googlegroups.com

 

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com



-- 

FORUM RULES (986+ 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. 

 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

 

--

To post to this group, send email to excel-macros@googlegroups.com

 

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com 
  

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to 

Re: $$Excel-Macros$$ I want to learn macro from basic level

[Mangesh Vimay]

It's really good to learn VBA Fundamentals.

Thanks Rajan.


mANgeSH.

On Tue, Jun 12, 2012 at 7:23 PM, Rajan_Verma wrote:

> Hi  Guys
>
> ** **
>
> Download from this Link for excel 2007
>
> ** **
>
>
> http://www.comp.nus.edu.sg/~justin88/Excel%202007%20Power%20Programming%20With%20VBA.pdf
> 
>
> ** **
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Rakesh Kumar Sharma
> *Sent:* 12 June 2012 7:04
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ I want to learn macro from basic level
>
> ** **
>
> Hi Rajan,
>
> Plz send me on my email idif possible
>
> 
>
> On Tue, Jun 12, 2012 at 6:15 PM, Rajan_Verma 
> wrote:
>
> Excel Power programming with VBA J
>
>  
>
> Either you can download from internet its free or I will send you on your
> email id .. 
>
> Really nice book to start from scratch.
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Rakesh Kumar Sharma
> *Sent:* 12 June 2012 3:00
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ I want to learn macro from basic level
>
>  
>
> Hi Masters,
>
> If you have any attachment which can help me to learn excel macro from
> starting point, plz share.
>
>
> --
> *Regards,
>
> **Rakesh Kumar Sharma**
> **Contact: +91-9971024741*
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> *Regards,
>
> **Rakesh Kumar Sharma**
> **Contact: +91-9971024741**
>
> *
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ 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 b

Re: $$Excel-Macros$$ Sheet Requirements

[Mangesh Vimay]

Hi Dear,

It happens with everybody specially when someone tries to learn new
concepts of IT or any other topic. So keep going and this group is good to
help you.

MangeSH

On Tue, Jun 12, 2012 at 6:45 PM, Deba Ranjan  wrote:

> Thanks.
>i love excel very much, Actually i keep on trying the coding But
> really i am so sorry that i really don't have this Idea. i purchased books
> for VBA macros and Excel, and i am trying my best to do so. Actually i am
> very new to this concepts (Means VBA coding).  And even i am trying to
> learn from this group as well.
>   I adopted to learn one by one. Let me tell you honestly, i have no
> system at my home. And what ever i learn, i learnt at Office but that too
> also i have many few times to learnt myself. So its my drawback.
>
>  i hope i would able  very few things a day, Any way thanks for
> suggesting that. i will keep trying. i have very confusion in coding when i
> go trough the books. Like String, long etc.  
>
>
> Thanks & Regards,
> *Deba Ranjan P*
>
>
> 
>
>
> On Tue, Jun 12, 2012 at 6:34 PM, dguillett1  wrote:
>
>>   Forgive me but as I recall you have been a part of this group for
>> awhile. If so, you should have learned enough to do this yourself.
>>
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* Deba Ranjan 
>> *Sent:* Tuesday, June 12, 2012 6:45 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Sheet Requirements
>>
>> Dear Experts,
>>
>> i have attached a file which contains many sheets. in every sheets
>> there contains data. i want a button which on clicking the whole sheet data
>> consolidated. Please find the attached.
>>
>> thanks...
>>
>>
>> Thanks & Regards,
>> *Deba Ranjan P*
>>
>>
>> 
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Proble

Re: $$Excel-Macros$$ Date

[ankur]

Dear Chandra,
Try this one






DATEDIF(A2,B2,"d")  for Formula1(Days)

TEXT(B2-A2,"[h]:mm:ss") for Formula2(hr:mm:ss)

CONCATENATE(C2," Days ",HOUR(D2)," Hr ",MINUTE(D2)," Mins ",SECOND(D2),"
Sec")  for Formula3

Regards:
CMA Ankur Pandey





On Tue, Jun 12, 2012 at 7:58 PM, NOORAIN ANSARI wrote:

> Dear Chandra,
>
> Please see attached sheet.
>
>
> On Tue, Jun 12, 2012 at 7:15 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello,
>>
>> Can you please help me with attached excel.
>>
>> Thanks in advance.
>>
>> Regards,
>>
>> Chandra Shekar B
>>
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
>
>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Date

[NOORAIN ANSARI]

Dear Chandra,

Please see attached sheet.

On Tue, Jun 12, 2012 at 7:15 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hello,
>
> Can you please help me with attached excel.
>
> Thanks in advance.
>
> Regards,
>
> Chandra Shekar B
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Copy of Date(solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Date

[Ahmed Honest]

Hi Chandra,

PFA  and see if it helps

Thanks,



On Tue, Jun 12, 2012 at 4:45 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hello,
>
> Can you please help me with attached excel.
>
> Thanks in advance.
>
> Regards,
>
> Chandra Shekar B
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Ahmed Bawazir
*احمد باوزير*

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Date and Time Solution.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

RE: $$Excel-Macros$$ I want to learn macro from basic level

[Rajan_Verma]

Hi  Guys

 

Download from this Link for excel 2007

 

http://www.comp.nus.edu.sg/~justin88/Excel%202007%20Power%20Programming%20Wi
th%20VBA.pdf

 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rakesh Kumar Sharma
Sent: 12 June 2012 7:04
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ I want to learn macro from basic level

 

Hi Rajan,

Plz send me on my email idif possible



On Tue, Jun 12, 2012 at 6:15 PM, Rajan_Verma 
wrote:

Excel Power programming with VBA J

 

Either you can download from internet its free or I will send you on your
email id .. 

Really nice book to start from scratch.

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rakesh Kumar Sharma
Sent: 12 June 2012 3:00
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ I want to learn macro from basic level

 

Hi Masters,

If you have any attachment which can help me to learn excel macro from
starting point, plz share.


-- 
Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
 




-- 
Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741



-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To uns

Re: $$Excel-Macros$$ I want to learn macro from basic level

[chhajersandeep]

Please send me also @ chhajersand...@gmail.com

Sandeep Chhajer.

Sent on my BlackBerry® from Vodafone

-Original Message-
From: Rakesh Kumar Sharma 
Sender: excel-macros@googlegroups.com
Date: Tue, 12 Jun 2012 19:03:51 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ I want to learn macro from basic level

Hi Rajan,

Plz send me on my email idif possible


On Tue, Jun 12, 2012 at 6:15 PM, Rajan_Verma wrote:

> Excel Power programming with VBA J
>
> ** **
>
> Either you can download from internet its free or I will send you on your
> email id .. 
>
> Really nice book to start from scratch.
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Rakesh Kumar Sharma
> *Sent:* 12 June 2012 3:00
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ I want to learn macro from basic level
>
> ** **
>
> Hi Masters,
>
> If you have any attachment which can help me to learn excel macro from
> starting point, plz share.
>
>
> --
> *Regards,
>
> **Rakesh Kumar Sharma**
> **Contact: +91-9971024741**
>
> *
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
*Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741
*

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to

Re: $$Excel-Macros$$ I want to learn macro from basic level

[karthik N]

Hi Rajan

My mail id is n.karthi...@gmail.com kindly send the same

Regards
karthik.N


On Tue, Jun 12, 2012 at 6:15 PM, Rajan_Verma wrote:

> Excel Power programming with VBA J
>
> ** **
>
> Either you can download from internet its free or I will send you on your
> email id .. 
>
> Really nice book to start from scratch.
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Rakesh Kumar Sharma
> *Sent:* 12 June 2012 3:00
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ I want to learn macro from basic level
>
> ** **
>
> Hi Masters,
>
> If you have any attachment which can help me to learn excel macro from
> starting point, plz share.
>
>
> --
> *Regards,
>
> **Rakesh Kumar Sharma**
> **Contact: +91-9971024741**
>
> *
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 

*Regards*

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Date

[Chandra Shekar]

Hello,

Can you please help me with attached excel.

Thanks in advance.

Regards,

Chandra Shekar B

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

Re: $$Excel-Macros$$ I want to learn macro from basic level

[Rakesh Kumar Sharma]

Hi Rajan,

Plz send me on my email idif possible


On Tue, Jun 12, 2012 at 6:15 PM, Rajan_Verma wrote:

> Excel Power programming with VBA J
>
> ** **
>
> Either you can download from internet its free or I will send you on your
> email id .. 
>
> Really nice book to start from scratch.
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Rakesh Kumar Sharma
> *Sent:* 12 June 2012 3:00
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ I want to learn macro from basic level
>
> ** **
>
> Hi Masters,
>
> If you have any attachment which can help me to learn excel macro from
> starting point, plz share.
>
>
> --
> *Regards,
>
> **Rakesh Kumar Sharma**
> **Contact: +91-9971024741**
>
> *
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
*Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741
*

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Sheet Requirements

[Deba Ranjan]

Thanks.
   i love excel very much, Actually i keep on trying the coding But
really i am so sorry that i really don't have this Idea. i purchased books
for VBA macros and Excel, and i am trying my best to do so. Actually i am
very new to this concepts (Means VBA coding).  And even i am trying to
learn from this group as well.
  I adopted to learn one by one. Let me tell you honestly, i have no
system at my home. And what ever i learn, i learnt at Office but that too
also i have many few times to learnt myself. So its my drawback.

 i hope i would able  very few things a day, Any way thanks for
suggesting that. i will keep trying. i have very confusion in coding when i
go trough the books. Like String, long etc.  


Thanks & Regards,
*Deba Ranjan P*





On Tue, Jun 12, 2012 at 6:34 PM, dguillett1  wrote:

>   Forgive me but as I recall you have been a part of this group for
> awhile. If so, you should have learned enough to do this yourself.
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Deba Ranjan 
> *Sent:* Tuesday, June 12, 2012 6:45 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Sheet Requirements
>
> Dear Experts,
>
> i have attached a file which contains many sheets. in every sheets
> there contains data. i want a button which on clicking the whole sheet data
> consolidated. Please find the attached.
>
> thanks...
>
>
> Thanks & Regards,
> *Deba Ranjan P*
>
>
> 
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Sheet Requirements

[Divaker Pandey]

good reply don

On Tue, Jun 12, 2012 at 6:34 PM, dguillett1  wrote:

>   Forgive me but as I recall you have been a part of this group for
> awhile. If so, you should have learned enough to do this yourself.
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Deba Ranjan 
> *Sent:* Tuesday, June 12, 2012 6:45 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Sheet Requirements
>
> Dear Experts,
>
> i have attached a file which contains many sheets. in every sheets
> there contains data. i want a button which on clicking the whole sheet data
> consolidated. Please find the attached.
>
> thanks...
>
>
> Thanks & Regards,
> *Deba Ranjan P*
>
>
> 
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Sheet Requirements

[dguillett1]

Forgive me but as I recall you have been a part of this group for awhile. If 
so, you should have learned enough to do this yourself.

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com

From: Deba Ranjan 
Sent: Tuesday, June 12, 2012 6:45 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Sheet Requirements

Dear Experts,

i have attached a file which contains many sheets. in every sheets there 
contains data. i want a button which on clicking the whole sheet data 
consolidated. Please find the attached. 

thanks...



Thanks & Regards,
Deba Ranjan P





-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

[Divaker Pandey]

I have created custom menu tab, but if i have open two workbook and switch
one to another, then i want to activate customtab menu, when i switch on
applicationworkbook. this time it always goto Home tab


Divaker

On Tue, Jun 12, 2012 at 6:25 PM, NOORAIN ANSARI wrote:

> Dear Divakar,
>
> Please see Ashish Koul created My Menu Add-In.
> I think your need to create this type of custom Menu.
>
> Please check and revert.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
> On Tue, Jun 12, 2012 at 5:55 PM, Divaker Pandey wrote:
>
>> Thanks for reply ranjan, but i want that whenever i activate workbook
>> that contains customtab, it must selected by detault.
>>
>>
>> On Tue, Jun 12, 2012 at 5:52 PM, Rajan_Verma wrote:
>>
>>> You can read about CustomUI Editor , it basically used to manipulate and
>>> create new ribbon in Excel 2007 and later
>>>
>>> ** **
>>>
>>> * *
>>>
>>> *Regards*
>>>
>>> *Rajan verma*
>>>
>>> *+91 7838100659 [IM-Gtalk]*
>>>
>>> ** **
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *Divaker Pandey
>>> *Sent:* 12 June 2012 3:03
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ want to add our own custom button and
>>> Tab in Excel 2007 name in place of add-in
>>>
>>> ** **
>>>
>>> Hi Expert,
>>>
>>> One more question if, i want to select my Custom Menu tab on each time
>>> workbook window activation, how i can i do it.
>>>
>>> Divaker
>>>
>>> On Mon, Apr 2, 2012 at 2:18 PM, Divaker Pandey 
>>> wrote:
>>>
>>> Dear Ashish,
>>>
>>> Thanks from my bottom of hearts.
>>>
>>> I salute you.
>>>
>>> Divaker
>>>
>>> ** **
>>>
>>> On Fri, Mar 30, 2012 at 11:30 PM, Sam Mathai Chacko 
>>> wrote:
>>>
>>> Try this
>>>
>>> http://www.excelfox.com/forum/f10/how-add-new-ribbon-tab-excel-26/
>>>
>>> Regards,
>>> Sam Mathai Chacko
>>>
>>> ** **
>>>
>>> On Fri, Mar 30, 2012 at 9:37 PM, ashish koul 
>>> wrote:
>>>
>>> check  this http://www.rondebruin.nl/ribbon.htm#Examples 
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> On Fri, Mar 30, 2012 at 12:44 PM, Divaker Pandey 
>>> wrote:
>>>
>>> Please help,
>>>
>>> ** **
>>>
>>> On Thu, Mar 29, 2012 at 4:31 PM, Divaker Pandey 
>>> wrote:
>>>
>>> thanks for reply noorain
>>>
>>> But I want as in attached snapshot. Custom Menu
>>>
>>> hope you will help soon.
>>>
>>> Divaker
>>>
>>>
>>>
>>>
>>>
>>>
>>> 
>>>
>>> On Thu, Mar 29, 2012 at 9:33 AM, Darwin Chan <
>>> darwin.chankaw...@gmail.com> wrote:
>>>
>>> Hi Noorain,
>>>
>>> ** **
>>>
>>> Regarding the code provided from above, do the custom control button and
>>> tab include all operations too?
>>>
>>> ** **
>>>
>>> For example, the sorting button, the operations include in the following
>>> code? I would like to learn more from this.
>>>
>>> ** **
>>>
>>> .Caption = "Sort Names Descending"
>>> .OnAction = "SortList"
>>> .Parameter = "Dsc" 
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> 2012/3/29 NOORAIN ANSARI 
>>>
>>> See attached add-in's coding for reference
>>>
>>> On Wed, Mar 28, 2012 at 9:22 PM, Divaker Pandey 
>>> wrote:
>>>
>>>
>>> Hi Expert,
>>>
>>> I want to add our own custom button and Tab in Excel 2007 name in place
>>> add-in.
>>>
>>> Divaker
>>>
>>> --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>>
>>>
>>> 
>>>
>>>
>>> -- 
>>>
>>> Thanks & regards,
>>>
>>> Noorain Ansari
>>>
>>> *http://noorainansari.com/*
>>>
>>> *http://excelmacroworld.blogspot.com/*
>>> 
>>>
>>>  
>>>
>>> ** **
>>>
>>> --
>>> FORUM RULES (986+ 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 bre

Re: $$Excel-Macros$$ Date format change by running the macro

[dguillett1]

Try

Sub FormulaToEndOffset1SAS()
Dim lr As Long
With ActiveCell

lr = Cells(.Row, .Column).End(xlDown).Row
With Range(Cells(.Row, .Column + 1), Cells(lr, .Column + 1))
.Formula = _
"=IF(ISERR(DATE(LEFT(A" & .Row & ",4),MID(A" & .Row & ",5,2)," & _
"RIGHT(A" & .Row & ",2))),,DATE(LEFT(A" & .Row & ",4), " & _
"MID(A" & .Row & ",5,2),RIGHT(A" & .Row & ",2)))"
.NumberFormat = "dd/mmm/"
.Value = .Value
End With

End With
End Sub
‘
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com

From: ankur 
Sent: Tuesday, June 12, 2012 5:50 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Date format change by running the macro

hi Experts
i use this code to solve the query with slight modification,i want date format 
in adjacent cell..
i used Macro for this..
But problem is ,this code can run upto specific no. of row i.e 475
i want to be it a dynamic ...i.e it should work with based on selection of 
range onlylike  solution of Krishna Sir is doing..what modification is 
needed in my codes

File is attached for your reference
thanks in advance


Sub ChgMyFormat()

ActiveCell.Offset(0, 1).Range("A1").Select
ActiveCell.FormulaR1C1 = _

"=IF(ISERR(DATE(LEFT(RC[-1],4),MID(RC[-1],5,2),RIGHT(RC[-1],2))),,DATE(LEFT(RC[-1],4),MID(RC[-1],5,2),RIGHT(RC[-1],2)))"
ActiveCell.Select
Selection.AutoFill Destination:=ActiveCell.Range("A1:A475")
ActiveCell.Range("A1:A475").Select
ActiveCell.Columns("A:A").EntireColumn.Select
Selection.Copy

Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats
Selection.NumberFormat = "dd/mmm/"
ActiveCell.Columns("A:A").EntireColumn.EntireColumn.AutoFit
ActiveCell.Offset(0, 1).Columns("A:A").EntireColumn.Select
Application.CutCopyMode = False

ActiveCell.Offset(0, -1).Range("A1").Select
End Sub

Regards:
CMA Ankur Pandey

 




On Tue, Jun 12, 2012 at 2:32 PM, Ashish Bhalara  
wrote:

  Thank you Mr.Krish it is exactly what i want.


  On Tue, Jun 12, 2012 at 2:21 PM, ankur  wrote:

Hi Ahmed

Sorry for this ...Now i had changed the settings.Thanks for correcting 
me..

Regards:
CMA Ankur Pandey

 




On Tue, Jun 12, 2012 at 2:20 PM, ankur  wrote:

  Hi Ahmed

  Sorry for this ...Now i had changed the settings.Thanks for 
correcting me..


  Regards:
  CMA Ankur Pandey 


   




  On Tue, Jun 12, 2012 at 2:11 PM, Ahmed Honest  
wrote:

Dear Ankur,

Please if you don't mind will you make your font sytle and size as a 
simple Or plain one. It looks too ODD.

Thanks for your understanding.

Regards,


On Tue, Jun 12, 2012 at 11:38 AM, ankur  wrote:

  HI ASHISH
  I TRIED THIS CODE FOR YOUR SOLUTION ,BUT IT IS NOT SO GOODbecause 
i dont know how to stop the code after the blank cellsExperts will guide me 
in this issue how to remove this flawfile is attached for your reference

  Sub chgDateFormat()

  ActiveCell.Offset(0, 1).Range("A1").Select
  ActiveCell.FormulaR1C1 = _
  "=DATE(LEFT(RC[-1],4),MID(RC[-1],5,2),RIGHT(RC[-1],2))"
  ActiveCell.Select
  Selection.AutoFill Destination:=ActiveCell.Range("A1:A500")
  ActiveCell.Range("A1:A1").Select
  End Sub




  Regards:
  CMA Ankur Pandey

   Visit My Site




  On Tue, Jun 12, 2012 at 1:04 PM, Ashish Bhalara 
 wrote:

Dear sir,

I have data in which date written in 20120412 format and i want to 
make macro to which transfer the format to 12-Apr-2012 by running the macro on 
selection range. Please help me in my below code.

Sub Macro1()
Dim selct As Range
selct = Range.Select
Range = WorksheetFunction.TEXT(TEXT(selct, "-00-00"), 
"DD-MMM-")
End Sub

Thanks & regards. 

Ashish Bhalara
9624111822



-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. 
Forum owners and members are not responsible for any loss.
 

-

Re: $$Excel-Macros$$ I want to learn macro from basic level

[amar . gurkha]

Hi Rajan,

Please send the same on my email I'd on amar.mas...@gmail.com

Regards,
Amar
Sent on my BlackBerry® from Vodafone

-Original Message-
From: "Rajan_Verma" 
Sender: excel-macros@googlegroups.com
Date: Tue, 12 Jun 2012 18:15:14 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ I want to learn macro from basic level

Excel Power programming with VBA J

 

Either you can download from internet its free or I will send you on your
email id .. 

Really nice book to start from scratch.

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rakesh Kumar Sharma
Sent: 12 June 2012 3:00
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ I want to learn macro from basic level

 

Hi Masters,

If you have any attachment which can help me to learn excel macro from
starting point, plz share.


-- 
Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741



-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

RE: $$Excel-Macros$$ I want to learn macro from basic level

[Rajan_Verma]

Excel Power programming with VBA J

 

Either you can download from internet its free or I will send you on your
email id .. 

Really nice book to start from scratch.

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rakesh Kumar Sharma
Sent: 12 June 2012 3:00
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ I want to learn macro from basic level

 

Hi Masters,

If you have any attachment which can help me to learn excel macro from
starting point, plz share.


-- 
Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741



-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

RE: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

[Rajan_Verma]

Hi dharti

See the attached sheet.. I have used an class module to get application
events , 

 

HTH

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dhartiku...@gmail.com
Sent: 12 June 2012 3:31
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ call addin fuction before activeworkbook close
.. Urgent

 

Urgently required code please.

Sent from BlackBerryR on Airtel

  _  

From: Dhartikumar Sahu  

Sender: excel-macros@googlegroups.com 

Date: Tue, 12 Jun 2012 10:46:34 +0530

To: 

ReplyTo: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ call addin fuction before activeworkbook close
.. Urgent

 

hi group

 

i want a vba code for call addin fuction before any workbook close.

 

please provide me code please..


 

-- 

Regards,

Dhartikumar Sahu

Sr.Database Manager - Institutional Equities

 IDBI Capital Markets Services Ltd

5th Floor, Mafatlal Centre | Nariman Point | Mumbai - 21

Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450

 

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com 

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Book1.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Error handling matter

[Divaker Pandey]

thanks noorain bhai, but i want some more. please provide me

Divaker

On Tue, Jun 12, 2012 at 5:57 PM, NOORAIN ANSARI wrote:

> Dear Divaker,
>
> Please read CPearson site..Here is good example Error Handlers.
>
> http://www.cpearson.com/excel/errorhandling.htm
>
>
> On Tue, Jun 12, 2012 at 3:05 PM, Divaker Pandey wrote:
>
>> Hi Experts,
>>
>> can you please provide me some matter on error handling in vba
>> application.
>>
>> Divaker
>>
>>
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
>
>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Error handling matter

[NOORAIN ANSARI]

Dear Divaker,

Please read CPearson site..Here is good example Error Handlers.

http://www.cpearson.com/excel/errorhandling.htm

On Tue, Jun 12, 2012 at 3:05 PM, Divaker Pandey  wrote:

> Hi Experts,
>
> can you please provide me some matter on error handling in vba application.
>
> Divaker
>
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

[Divaker Pandey]

Thanks for reply ranjan, but i want that whenever i activate workbook that
contains customtab, it must selected by detault.

On Tue, Jun 12, 2012 at 5:52 PM, Rajan_Verma wrote:

> You can read about CustomUI Editor , it basically used to manipulate and
> create new ribbon in Excel 2007 and later
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Divaker Pandey
> *Sent:* 12 June 2012 3:03
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ want to add our own custom button and Tab
> in Excel 2007 name in place of add-in
>
> ** **
>
> Hi Expert,
>
> One more question if, i want to select my Custom Menu tab on each time
> workbook window activation, how i can i do it.
>
> Divaker
>
> On Mon, Apr 2, 2012 at 2:18 PM, Divaker Pandey 
> wrote:
>
> Dear Ashish,
>
> Thanks from my bottom of hearts.
>
> I salute you.
>
> Divaker
>
> ** **
>
> On Fri, Mar 30, 2012 at 11:30 PM, Sam Mathai Chacko 
> wrote:
>
> Try this
>
> http://www.excelfox.com/forum/f10/how-add-new-ribbon-tab-excel-26/
>
> Regards,
> Sam Mathai Chacko
>
> ** **
>
> On Fri, Mar 30, 2012 at 9:37 PM, ashish koul 
> wrote:
>
> check  this http://www.rondebruin.nl/ribbon.htm#Examples 
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> On Fri, Mar 30, 2012 at 12:44 PM, Divaker Pandey 
> wrote:
>
> Please help,
>
> ** **
>
> On Thu, Mar 29, 2012 at 4:31 PM, Divaker Pandey 
> wrote:
>
> thanks for reply noorain
>
> But I want as in attached snapshot. Custom Menu
>
> hope you will help soon.
>
> Divaker
>
>
>
>
>
>
> 
>
> On Thu, Mar 29, 2012 at 9:33 AM, Darwin Chan 
> wrote:
>
> Hi Noorain,
>
> ** **
>
> Regarding the code provided from above, do the custom control button and
> tab include all operations too?
>
> ** **
>
> For example, the sorting button, the operations include in the following
> code? I would like to learn more from this.
>
> ** **
>
> .Caption = "Sort Names Descending"
> .OnAction = "SortList"
> .Parameter = "Dsc" 
>
> ** **
>
> ** **
>
> ** **
>
> 2012/3/29 NOORAIN ANSARI 
>
> See attached add-in's coding for reference
>
> On Wed, Mar 28, 2012 at 9:22 PM, Divaker Pandey 
> wrote:
>
>
> Hi Expert,
>
> I want to add our own custom button and Tab in Excel 2007 name in place
> add-in.
>
> Divaker
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
>
>
> 
>
>
> -- 
>
> Thanks & regards,
>
> Noorain Ansari
>
> *http://noorainansari.com/*
>
> *http://excelmacroworld.blogspot.com/*
> 
>
>  
>
> ** **
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
>
>
> 
>
> ** **
>
> -- 
>
> Best Regards,
>
> Darwin Chan
>
> darwin.chankaw...@gmail.com
>
> kw42c...@yahoo.com.hk
>
> ** **
>
> --
> FORUM RULES (986+ 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 

RE: $$Excel-Macros$$ Error handling matter

[Rajan_Verma]

 

You can google on following topics:

 

1). Breakpoint

2).Step Forward

3). Watch Window

4) Immediate window

5) On Error 

6).Err Object property

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Divaker Pandey
Sent: 12 June 2012 3:05
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Error handling matter

 

Hi Experts,

can you please provide me some matter on error handling in vba application.

Divaker
 

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

RE: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

[Rajan_Verma]

You can read about CustomUI Editor , it basically used to manipulate and
create new ribbon in Excel 2007 and later

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Divaker Pandey
Sent: 12 June 2012 3:03
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ want to add our own custom button and Tab in
Excel 2007 name in place of add-in

 

Hi Expert,

One more question if, i want to select my Custom Menu tab on each time
workbook window activation, how i can i do it.

Divaker

On Mon, Apr 2, 2012 at 2:18 PM, Divaker Pandey  wrote:

Dear Ashish,

Thanks from my bottom of hearts.

I salute you.

Divaker

 

On Fri, Mar 30, 2012 at 11:30 PM, Sam Mathai Chacko 
wrote:

Try this

http://www.excelfox.com/forum/f10/how-add-new-ribbon-tab-excel-26/

Regards,
Sam Mathai Chacko

 

On Fri, Mar 30, 2012 at 9:37 PM, ashish koul  wrote:

check  this http://www.rondebruin.nl/ribbon.htm#Examples 

 

 

 

 

 

On Fri, Mar 30, 2012 at 12:44 PM, Divaker Pandey 
wrote:

Please help,

 

On Thu, Mar 29, 2012 at 4:31 PM, Divaker Pandey  wrote:

thanks for reply noorain

But I want as in attached snapshot. Custom Menu

hope you will help soon.

Divaker








On Thu, Mar 29, 2012 at 9:33 AM, Darwin Chan 
wrote:

Hi Noorain,

 

Regarding the code provided from above, do the custom control button and tab
include all operations too?

 

For example, the sorting button, the operations include in the following
code? I would like to learn more from this.

 

.Caption = "Sort Names Descending"
.OnAction = "SortList"
.Parameter = "Dsc" 

 

 

 

2012/3/29 NOORAIN ANSARI 

See attached add-in's coding for reference

On Wed, Mar 28, 2012 at 9:22 PM, Divaker Pandey  wrote:


Hi Expert,

I want to add our own custom button and Tab in Excel 2007 name in place
add-in.

Divaker

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com






-- 

Thanks & regards,

Noorain Ansari

http://noorainansari.com/

  http://excelmacroworld.blogspot.com/

 

 

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com





 

-- 

Best Regards,

Darwin Chan

darwin.chankaw...@gmail.com

kw42c...@yahoo.com.hk

 

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

 

 

-- 
FORUM RULES (986+ 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

RE: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

[Rajan_Verma]

 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Divaker Pandey
Sent: 12 June 2012 4:00
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ call addin fuction before activeworkbook close
.. Urgent

 


Hi Dharti,

If i could understand your problem, then please use following code


Private Sub Workbook_BeforeClose(Cancel As Boolean)
   
 Application.Run "'" + ThisWorkbook.name + "'!MacroToRun", argument1,
argument2, argumentN

End Sub




On Tue, Jun 12, 2012 at 3:45 PM, Divaker Pandey  wrote:

can you provide more details





On Tue, Jun 12, 2012 at 3:31 PM,  wrote:

Any update.

Sent from BlackBerryR on Airtel

  _  

From: dhartiku...@gmail.com 

Date: Tue, 12 Jun 2012 07:15:16 +

To: 

ReplyTo: dhartiku...@gmail.com 

Subject: Re: $$Excel-Macros$$ call addin fuction before activeworkbook close
.. Urgent

 

Urgently required code please.

Sent from BlackBerryR on Airtel

  _  

From: Dhartikumar Sahu  

Sender: excel-macros@googlegroups.com 

Date: Tue, 12 Jun 2012 10:46:34 +0530

To: 

ReplyTo: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ call addin fuction before activeworkbook close
.. Urgent

 

hi group

 

i want a vba code for call addin fuction before any workbook close.

 

please provide me code please..


 

-- 

Regards,

Dhartikumar Sahu

Sr.Database Manager - Institutional Equities

 IDBI Capital Markets Services Ltd

5th Floor, Mafatlal Centre | Nariman Point | Mumbai - 21

Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450

 

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
  

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
 

 

 

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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) Ack

$$Excel-Macros$$ Sheet Requirements

[Deba Ranjan]

Dear Experts,

i have attached a file which contains many sheets. in every sheets
there contains data. i want a button which on clicking the whole sheet data
consolidated. Please find the attached.

thanks...


Thanks & Regards,
*Deba Ranjan P*




-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Conso_Dash_bd.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

[dhartikumar]

Will inform u status tommorow, I am left from offoce for a meeting.

Sent from BlackBerry® on Airtel

-Original Message-
From: Divaker Pandey 
Sender: excel-macros@googlegroups.com
Date: Tue, 12 Jun 2012 16:40:15 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ call addin fuction before activeworkbook close
 .. Urgent

try this one

Private Sub Workbook_BeforeClose(Cancel As Boolean)

 Application.Run "'" + "idbiuploader.xlam" + "'!uploadingmodel"

End Sub


On Tue, Jun 12, 2012 at 4:22 PM, Dhartikumar Sahu wrote:

> hi divakar
>
> i have a addin
>
> whenever i close any workbook , it should be run from addins
>
> addinfile name: idbiuploader.xlam
> macro  name : uploadingmodel
>
> please help..
>
> Dhartikumar
>
>
> On Tue, Jun 12, 2012 at 4:00 PM, Divaker Pandey wrote:
>
>>
>> Hi Dharti,
>>
>> If i could understand your problem, then please use following code
>>
>>
>> Private Sub Workbook_BeforeClose(Cancel As Boolean)
>>
>>  Application.Run "'" + ThisWorkbook.name + "'!MacroToRun", argument1,
>> argument2, argumentN
>>
>> End Sub
>>
>>
>>
>>
>> On Tue, Jun 12, 2012 at 3:45 PM, Divaker Pandey wrote:
>>
>>> can you provide more details
>>>
>>>
>>>
>>> On Tue, Jun 12, 2012 at 3:31 PM,  wrote:
>>>
 **
 Any update.
 Sent from BlackBerry® on Airtel
 --
 *From: * dhartiku...@gmail.com
 *Date: *Tue, 12 Jun 2012 07:15:16 +
 *To: *
 *ReplyTo: * dhartiku...@gmail.com
 *Subject: *Re: $$Excel-Macros$$ call addin fuction before
 activeworkbook close .. Urgent

 Urgently required code please.
 Sent from BlackBerry® on Airtel
 --
 *From: * Dhartikumar Sahu 
 *Sender: * excel-macros@googlegroups.com
 *Date: *Tue, 12 Jun 2012 10:46:34 +0530
 *To: *
 *ReplyTo: * excel-macros@googlegroups.com
 *Subject: *$$Excel-Macros$$ call addin fuction before activeworkbook
 close .. Urgent

 hi group

 i want a vba code for call addin fuction before any workbook close.

 please provide me code please..

 --

 *Regards,*

 *Dhartikumar Sahu*

 Sr.Database Manager - Institutional Equities

 * **IDBI Capital Markets Services Ltd*

 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21

 Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450

  --
 FORUM RULES (986+ 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.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com

 --
 FORUM RULES (986+ 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.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com

>>>
>>>
>>  --
>> FORUM RULES (986+ 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
>> me

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

[Divaker Pandey]

try this one

Private Sub Workbook_BeforeClose(Cancel As Boolean)

 Application.Run "'" + "idbiuploader.xlam" + "'!uploadingmodel"

End Sub


On Tue, Jun 12, 2012 at 4:22 PM, Dhartikumar Sahu wrote:

> hi divakar
>
> i have a addin
>
> whenever i close any workbook , it should be run from addins
>
> addinfile name: idbiuploader.xlam
> macro  name : uploadingmodel
>
> please help..
>
> Dhartikumar
>
>
> On Tue, Jun 12, 2012 at 4:00 PM, Divaker Pandey wrote:
>
>>
>> Hi Dharti,
>>
>> If i could understand your problem, then please use following code
>>
>>
>> Private Sub Workbook_BeforeClose(Cancel As Boolean)
>>
>>  Application.Run "'" + ThisWorkbook.name + "'!MacroToRun", argument1,
>> argument2, argumentN
>>
>> End Sub
>>
>>
>>
>>
>> On Tue, Jun 12, 2012 at 3:45 PM, Divaker Pandey wrote:
>>
>>> can you provide more details
>>>
>>>
>>>
>>> On Tue, Jun 12, 2012 at 3:31 PM,  wrote:
>>>
 **
 Any update.
 Sent from BlackBerry® on Airtel
 --
 *From: * dhartiku...@gmail.com
 *Date: *Tue, 12 Jun 2012 07:15:16 +
 *To: *
 *ReplyTo: * dhartiku...@gmail.com
 *Subject: *Re: $$Excel-Macros$$ call addin fuction before
 activeworkbook close .. Urgent

 Urgently required code please.
 Sent from BlackBerry® on Airtel
 --
 *From: * Dhartikumar Sahu 
 *Sender: * excel-macros@googlegroups.com
 *Date: *Tue, 12 Jun 2012 10:46:34 +0530
 *To: *
 *ReplyTo: * excel-macros@googlegroups.com
 *Subject: *$$Excel-Macros$$ call addin fuction before activeworkbook
 close .. Urgent

 hi group

 i want a vba code for call addin fuction before any workbook close.

 please provide me code please..

 --

 *Regards,*

 *Dhartikumar Sahu*

 Sr.Database Manager - Institutional Equities

 * **IDBI Capital Markets Services Ltd*

 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21

 Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450

  --
 FORUM RULES (986+ 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.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com

 --
 FORUM RULES (986+ 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.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com

>>>
>>>
>>  --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> ---

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

[Dhartikumar Sahu]

hi divakar

i have a addin

whenever i close any workbook , it should be run from addins

addinfile name: idbiuploader.xlam
macro  name : uploadingmodel

please help..

Dhartikumar

On Tue, Jun 12, 2012 at 4:00 PM, Divaker Pandey  wrote:

>
> Hi Dharti,
>
> If i could understand your problem, then please use following code
>
>
> Private Sub Workbook_BeforeClose(Cancel As Boolean)
>
>  Application.Run "'" + ThisWorkbook.name + "'!MacroToRun", argument1,
> argument2, argumentN
>
> End Sub
>
>
>
>
> On Tue, Jun 12, 2012 at 3:45 PM, Divaker Pandey wrote:
>
>> can you provide more details
>>
>>
>>
>> On Tue, Jun 12, 2012 at 3:31 PM,  wrote:
>>
>>> **
>>> Any update.
>>> Sent from BlackBerry® on Airtel
>>> --
>>> *From: * dhartiku...@gmail.com
>>> *Date: *Tue, 12 Jun 2012 07:15:16 +
>>> *To: *
>>> *ReplyTo: * dhartiku...@gmail.com
>>> *Subject: *Re: $$Excel-Macros$$ call addin fuction before
>>> activeworkbook close .. Urgent
>>>
>>> Urgently required code please.
>>> Sent from BlackBerry® on Airtel
>>> --
>>> *From: * Dhartikumar Sahu 
>>> *Sender: * excel-macros@googlegroups.com
>>> *Date: *Tue, 12 Jun 2012 10:46:34 +0530
>>> *To: *
>>> *ReplyTo: * excel-macros@googlegroups.com
>>> *Subject: *$$Excel-Macros$$ call addin fuction before activeworkbook
>>> close .. Urgent
>>>
>>> hi group
>>>
>>> i want a vba code for call addin fuction before any workbook close.
>>>
>>> please provide me code please..
>>>
>>> --
>>>
>>> *Regards,*
>>>
>>> *Dhartikumar Sahu*
>>>
>>> Sr.Database Manager - Institutional Equities
>>>
>>> * **IDBI Capital Markets Services Ltd*
>>>
>>> 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21
>>>
>>> Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450
>>>
>>>  --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>> --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>
>>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 

*Regards,*

*Dhartikumar Sahu*

Sr.Database Manager - Institutional Equities

* **IDBI Capital Markets Services Ltd*

5th Floor, Mafatlal C

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

[Divaker Pandey]

Hi Dharti,

If i could understand your problem, then please use following code


Private Sub Workbook_BeforeClose(Cancel As Boolean)

 Application.Run "'" + ThisWorkbook.name + "'!MacroToRun", argument1,
argument2, argumentN

End Sub



On Tue, Jun 12, 2012 at 3:45 PM, Divaker Pandey  wrote:

> can you provide more details
>
>
>
> On Tue, Jun 12, 2012 at 3:31 PM,  wrote:
>
>> **
>> Any update.
>> Sent from BlackBerry® on Airtel
>> --
>> *From: * dhartiku...@gmail.com
>> *Date: *Tue, 12 Jun 2012 07:15:16 +
>> *To: *
>> *ReplyTo: * dhartiku...@gmail.com
>> *Subject: *Re: $$Excel-Macros$$ call addin fuction before activeworkbook
>> close .. Urgent
>>
>> Urgently required code please.
>> Sent from BlackBerry® on Airtel
>> --
>> *From: * Dhartikumar Sahu 
>> *Sender: * excel-macros@googlegroups.com
>> *Date: *Tue, 12 Jun 2012 10:46:34 +0530
>> *To: *
>> *ReplyTo: * excel-macros@googlegroups.com
>> *Subject: *$$Excel-Macros$$ call addin fuction before activeworkbook
>> close .. Urgent
>>
>> hi group
>>
>> i want a vba code for call addin fuction before any workbook close.
>>
>> please provide me code please..
>>
>> --
>>
>> *Regards,*
>>
>> *Dhartikumar Sahu*
>>
>> Sr.Database Manager - Institutional Equities
>>
>> * **IDBI Capital Markets Services Ltd*
>>
>> 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21
>>
>> Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450
>>
>>  --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

[Divaker Pandey]

can you provide more details


On Tue, Jun 12, 2012 at 3:31 PM,  wrote:

> **
> Any update.
> Sent from BlackBerry® on Airtel
> --
> *From: * dhartiku...@gmail.com
> *Date: *Tue, 12 Jun 2012 07:15:16 +
> *To: *
> *ReplyTo: * dhartiku...@gmail.com
> *Subject: *Re: $$Excel-Macros$$ call addin fuction before activeworkbook
> close .. Urgent
>
> Urgently required code please.
> Sent from BlackBerry® on Airtel
> --
> *From: * Dhartikumar Sahu 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Tue, 12 Jun 2012 10:46:34 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *$$Excel-Macros$$ call addin fuction before activeworkbook
> close .. Urgent
>
> hi group
>
> i want a vba code for call addin fuction before any workbook close.
>
> please provide me code please..
>
> --
>
> *Regards,*
>
> *Dhartikumar Sahu*
>
> Sr.Database Manager - Institutional Equities
>
> * **IDBI Capital Markets Services Ltd*
>
> 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21
>
> Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450
>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

[dhartikumar]

Any update.
Sent from BlackBerry® on Airtel

-Original Message-
From: dhartiku...@gmail.com
Date: Tue, 12 Jun 2012 07:15:16 
To: 
Reply-To: dhartiku...@gmail.com
Subject: Re: $$Excel-Macros$$ call addin fuction before activeworkbook close 
.. Urgent

Urgently required code please.
Sent from BlackBerry® on Airtel

-Original Message-
From: Dhartikumar Sahu 
Sender: excel-macros@googlegroups.com
Date: Tue, 12 Jun 2012 10:46:34 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ call addin fuction before activeworkbook close
 .. Urgent

hi group

i want a vba code for call addin fuction before any workbook close.

please provide me code please..

-- 

*Regards,*

*Dhartikumar Sahu*

Sr.Database Manager - Institutional Equities

* **IDBI Capital Markets Services Ltd*

5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21

Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

[dhartikumar]

Urgently required code please.
Sent from BlackBerry® on Airtel

-Original Message-
From: Dhartikumar Sahu 
Sender: excel-macros@googlegroups.com
Date: Tue, 12 Jun 2012 10:46:34 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ call addin fuction before activeworkbook close
 .. Urgent

hi group

i want a vba code for call addin fuction before any workbook close.

please provide me code please..

-- 

*Regards,*

*Dhartikumar Sahu*

Sr.Database Manager - Institutional Equities

* **IDBI Capital Markets Services Ltd*

5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21

Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ want to add our own custom button and Tab in Excel 2007 name in place of add-in

[Divaker Pandey]

Hi Expert,

One more question if, i want to select my Custom Menu tab on each time
workbook window activation, how i can i do it.

Divaker

On Mon, Apr 2, 2012 at 2:18 PM, Divaker Pandey  wrote:

> Dear Ashish,
>
> Thanks from my bottom of hearts.
>
> I salute you.
>
> Divaker
>
>
> On Fri, Mar 30, 2012 at 11:30 PM, Sam Mathai Chacko wrote:
>
>> Try this
>>
>> http://www.excelfox.com/forum/f10/how-add-new-ribbon-tab-excel-26/
>>
>> Regards,
>> Sam Mathai Chacko
>>
>>
>> On Fri, Mar 30, 2012 at 9:37 PM, ashish koul wrote:
>>
>>> check  this http://www.rondebruin.nl/ribbon.htm#Examples
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Fri, Mar 30, 2012 at 12:44 PM, Divaker Pandey wrote:
>>>
 Please help,


 On Thu, Mar 29, 2012 at 4:31 PM, Divaker Pandey wrote:

> thanks for reply noorain
>
> But I want as in attached snapshot. Custom Menu
>
> hope you will help soon.
>
> Divaker
>
>
>
>
>
>
> On Thu, Mar 29, 2012 at 9:33 AM, Darwin Chan <
> darwin.chankaw...@gmail.com> wrote:
>
>> Hi Noorain,
>>
>> Regarding the code provided from above, do the custom control button
>> and tab include all operations too?
>>
>> For example, the sorting button, the operations include in the
>> following code? I would like to learn more from this.
>>
>> .Caption = "Sort Names Descending"
>> .OnAction = "SortList"
>> .Parameter = "Dsc"
>>
>>
>>
>> 2012/3/29 NOORAIN ANSARI 
>>
>>> See attached add-in's coding for reference
>>>
>>> On Wed, Mar 28, 2012 at 9:22 PM, Divaker Pandey >> > wrote:
>>>

 Hi Expert,

 I want to add our own custom button and Tab in Excel 2007 name in
 place add-in.

 Divaker

 --
 FORUM RULES (986+ 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.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

>>>
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>>  ** *http://noorainansari.com/
>>> *
>>> *http://excelmacroworld.blogspot.com/*
>>>
>>>
>>>  --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> Best Regards,
>> Darwin Chan
>> darwin.chankaw...@gmail.com
>> kw42c...@yahoo.com.hk
>>
>>  --
>> FORUM RULES (986+ 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 signat

$$Excel-Macros$$ I want to learn macro from basic level

[Rakesh Kumar Sharma]

Hi Masters,

If you have any attachment which can help me to learn excel macro from
starting point, plz share.


-- 
*Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741
*

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Excel Function details collection required

[ankur]

Hi Divakar
You can Download file from here http://www.xlfdic.com/

It will explain you most of the functions with examples and syntax

Regards:
CMA Ankur Pandey





On Tue, Jun 12, 2012 at 1:54 PM, Divaker Pandey  wrote:

> Hi Members,
>
> I have required syntax and details  of each excel function.
>
> Please provide me.
>
> thanks in advance.
>
> Divaker
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Date format change by running the macro

[Ahmed Honest]

Dear Ankur,

Please if you don't mind will you make your font sytle and size as a simple
Or plain one. It looks too ODD.

Thanks for your understanding.

Regards,

On Tue, Jun 12, 2012 at 11:38 AM, ankur  wrote:

> *HI ASHISH
> **I TRIED THIS CODE FOR YOUR SOLUTION ,BUT IT IS NOT SO GOODbecause i
> dont know* how to stop the code after the blank cellsExperts will
> guide me in this issue how to remove this flawfile is attached for your
> reference
> *
> Sub chgDateFormat()
>
> ActiveCell.Offset(0, 1).Range("A1").Select
> ActiveCell.FormulaR1C1 = _
> "=DATE(LEFT(RC[-1],4),MID(RC[-1],5,2),RIGHT(RC[-1],2))"
> ActiveCell.Select
> Selection.AutoFill Destination:=ActiveCell.Range("A1:A500")
> ActiveCell.Range("A1:A1").Select
> End Sub
>
>
>
> *
> Regards:
> CMA Ankur Pandey
>
>  Visit My Site 
>
>
>
> On Tue, Jun 12, 2012 at 1:04 PM, Ashish Bhalara  > wrote:
>
>> Dear sir,
>>
>> I have data in which date written in 20120412 format and i want to make
>> macro to which transfer the format to 12-Apr-2012 by running the macro on
>> selection range. Please help me in my below code.
>>
>> Sub Macro1()
>> Dim selct As Range
>> selct = Range.Select
>> Range = WorksheetFunction.TEXT(TEXT(selct, "-00-00"), "DD-MMM-")
>> End Sub
>>
>> Thanks & regards.
>>
>> Ashish Bhalara
>> 9624111822
>>
>>
>>
>>  --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Ahmed Bawazir
*احمد باوزير*

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Date format change by running the macro

[ankur]

*HI ASHISH
**I TRIED THIS CODE FOR YOUR SOLUTION ,BUT IT IS NOT SO GOODbecause i
dont know* how to stop the code after the blank cellsExperts will guide
me in this issue how to remove this flawfile is attached for your
reference
*
Sub chgDateFormat()

ActiveCell.Offset(0, 1).Range("A1").Select
ActiveCell.FormulaR1C1 = _
"=DATE(LEFT(RC[-1],4),MID(RC[-1],5,2),RIGHT(RC[-1],2))"
ActiveCell.Select
Selection.AutoFill Destination:=ActiveCell.Range("A1:A500")
ActiveCell.Range("A1:A1").Select
End Sub



*
Regards:
CMA Ankur Pandey

 Visit My Site 



On Tue, Jun 12, 2012 at 1:04 PM, Ashish Bhalara
wrote:

> Dear sir,
>
> I have data in which date written in 20120412 format and i want to make
> macro to which transfer the format to 12-Apr-2012 by running the macro on
> selection range. Please help me in my below code.
>
> Sub Macro1()
> Dim selct As Range
> selct = Range.Select
> Range = WorksheetFunction.TEXT(TEXT(selct, "-00-00"), "DD-MMM-")
> End Sub
>
> Thanks & regards.
>
> Ashish Bhalara
> 9624111822
>
>
>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Date Format.xlsm
Description: Binary data

$$Excel-Macros$$ Excel Function details collection required

[Divaker Pandey]

Hi Members,

I have required syntax and details  of each excel function.

Please provide me.

thanks in advance.

Divaker

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Date format change by running the macro

[Krishna Kumar]

Hi

Select the range and run this macro

Sub kTest()
Dim x
With Selection
x = .Address
.Value = Evaluate("if(isnumber(" & x & "),TEXT(" & x &
",""\-00\-00"")+0," & x & ")")
.NumberFormat = "dd-mmm-"
End With
End Sub

Kris
ExcelFox 

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[alvin567]

Hey,I am interested to find out how microsoft excel can generate different 
views for the report.

On Tuesday, June 12, 2012 3:18:09 PM UTC+8, VKB wrote:
>
>
>
> On Friday, June 8, 2012 10:21:59 PM UTC+3, Ayush Jain wrote:
>>
>> Hey all new and current posters,
>>  
>> Welcome to excel group,one of the largest online community of excel Fans!
>>  
>> I hope you enjoy your time here & find this forum to be a friendly and 
>> knowledgeable community. Please feel free to post a small introduction, a 
>> friendly hello or tell us a bit about yourself. Why not tell us where are 
>> you from, what you do, what your interests are, how old you are, which is 
>> your favourite excel site or blog is or anything else that comes to mind!
>>
>> Thanks for your time
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>
> On Friday, June 8, 2012 10:21:59 PM UTC+3, Ayush Jain wrote:
>>
>> Hey all new and current posters,
>>  
>> Welcome to excel group,one of the largest online community of excel Fans!
>>  
>> I hope you enjoy your time here & find this forum to be a friendly and 
>> knowledgeable community. Please feel free to post a small introduction, a 
>> friendly hello or tell us a bit about yourself. Why not tell us where are 
>> you from, what you do, what your interests are, how old you are, which is 
>> your favourite excel site or blog is or anything else that comes to mind!
>>
>> Thanks for your time
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ call addin fuction before activeworkbook close ...... Urgent

[dhartikumar]

Urgently required code please.
Sent from BlackBerry® on Airtel

-Original Message-
From: Dhartikumar Sahu 
Sender: excel-macros@googlegroups.com
Date: Tue, 12 Jun 2012 10:46:34 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ call addin fuction before activeworkbook close
 .. Urgent

hi group

i want a vba code for call addin fuction before any workbook close.

please provide me code please..

-- 

*Regards,*

*Dhartikumar Sahu*

Sr.Database Manager - Institutional Equities

* **IDBI Capital Markets Services Ltd*

5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21

Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[VKB]

On Friday, June 8, 2012 10:21:59 PM UTC+3, Ayush Jain wrote:
>
> Hey all new and current posters,
>  
> Welcome to excel group,one of the largest online community of excel Fans!
>  
> I hope you enjoy your time here & find this forum to be a friendly and 
> knowledgeable community. Please feel free to post a small introduction, a 
> friendly hello or tell us a bit about yourself. Why not tell us where are 
> you from, what you do, what your interests are, how old you are, which is 
> your favourite excel site or blog is or anything else that comes to mind!
>
> Thanks for your time
> Ayush Jain
> Group Manager
> Microsoft MVP
>

On Friday, June 8, 2012 10:21:59 PM UTC+3, Ayush Jain wrote:
>
> Hey all new and current posters,
>  
> Welcome to excel group,one of the largest online community of excel Fans!
>  
> I hope you enjoy your time here & find this forum to be a friendly and 
> knowledgeable community. Please feel free to post a small introduction, a 
> friendly hello or tell us a bit about yourself. Why not tell us where are 
> you from, what you do, what your interests are, how old you are, which is 
> your favourite excel site or blog is or anything else that comes to mind!
>
> Thanks for your time
> Ayush Jain
> Group Manager
> Microsoft MVP
>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com