Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code to call a macro......?
Dear Friends,
I need the VB code to call a specific macro from an addin when ever excel application is opened and call another macro when ever the excel application is closed. How ca this be done.......? Thanks in advance Regards Thyagaraj |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code to call a macro......?
In the Workbook:
Private Sub Workbook_Open() call macro x End Sub ___________________________ Private Sub Workbook_Close() call macro x End Sub Corey.... "Thyagaraj" wrote in message ups.com... Dear Friends, I need the VB code to call a specific macro from an addin when ever excel application is opened and call another macro when ever the excel application is closed. How ca this be done.......? Thanks in advance Regards Thyagaraj |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code to call a macro......?
Same answer to your previous post, use personal.xls.
Or put the code in the same events of your add-in. NickHK "Thyagaraj" wrote in message ups.com... Dear Friends, I need the VB code to call a specific macro from an addin when ever excel application is opened and call another macro when ever the excel application is closed. How ca this be done.......? Thanks in advance Regards Thyagaraj |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code to call a macro......?
NickHK wrote: Same answer to your previous post, use personal.xls. Or put the code in the same events of your add-in. NickHK "Thyagaraj" wrote in message ups.com... Dear Friends, I need the VB code to call a specific macro from an addin when ever excel application is opened and call another macro when ever the excel application is closed. How ca this be done.......? Thanks in advance Regards Thyagaraj Dear NickHK, I am unable to get the code, can u just tell me what exact code to put and where to put ( whether in the work sheet or in a module) Regards Thyagaraj |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code to call a macro......?
You need to select ThisWorkbook, then the Open and/or BeforeClose events.
NickHK "Thyagaraj" wrote in message ups.com... NickHK wrote: Same answer to your previous post, use personal.xls. Or put the code in the same events of your add-in. NickHK "Thyagaraj" wrote in message ups.com... Dear Friends, I need the VB code to call a specific macro from an addin when ever excel application is opened and call another macro when ever the excel application is closed. How ca this be done.......? Thanks in advance Regards Thyagaraj Dear NickHK, I am unable to get the code, can u just tell me what exact code to put and where to put ( whether in the work sheet or in a module) Regards Thyagaraj |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel code to call a macro when a certain value in a cell isselected. | Excel Worksheet Functions | |||
Insert macro name in code on call statement. | Excel Programming | |||
Call recorded macro from VBA code | Excel Programming | |||
Code in one workbook to call code in another XL file | Excel Programming | |||
How To Call VBA Code from Excel 4 Macro | Excel Programming |