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

In the Workbook:


Private Sub Workbook_Open()
call macro x
End Sub

___________________________

Private Sub Workbook_Close()
call macro x
End Sub

Corey....
"Thyagaraj" <haithyag@yahoo.com> wrote in message
news:1153195565.928111.56880@b28g2000cwb.googlegroups.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
>

Same answer to your previous post, use personal.xls.
Or put the code in the same events of your add-in.

NickHK

"Thyagaraj" <haithyag@yahoo.com> wrote in message
news:1153195565.928111.56880@b28g2000cwb.googlegroups.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
>

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" <haithyag@yahoo.com> wrote in message
> news:1153195565.928111.56880@b28g2000cwb.googlegroups.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

You need to select ThisWorkbook, then the Open and/or BeforeClose events.

NickHK

"Thyagaraj" <haithyag@yahoo.com> wrote in message
news:1153197139.544900.43630@m73g2000cwd.googlegroups.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" <haithyag@yahoo.com> wrote in message
> > news:1153195565.928111.56880@b28g2000cwb.googlegroups.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
>