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 <divake...@gmail.com> wrote:

can you provide more details





On Tue, Jun 12, 2012 at 3:31 PM, <dhartiku...@gmail.com> wrote:

Any update.....

Sent from BlackBerryR on Airtel

  _____  

From: dhartiku...@gmail.com 

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

To: <excel-macros@googlegroups.com>

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 <dhartiku...@gmail.com> 

Sender: excel-macros@googlegroups.com 

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

To: <excel-macros@googlegroups.com>

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
<mailto:excel-macros%2bunsubscr...@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
<mailto:excel-macros%2bunsubscr...@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

Reply via email to