Macro Recorder

I saved a macro to the personal.xls option in macro recorder. How do I access this from another workbook. Does the workbook I created the macro in have to be open?

Thanks for any help

Josh

Hi Josh, yes you have to have the otrher wb open in order to see the macros in the VBA Editor.

Regards
Jose Luis

Originally Posted by jhahes

I saved a macro to the personal.xls option in macro recorder. How do I access this from another workbook. Does the workbook I created the macro in have to be open?

Thanks for any help

Josh

But if it is in Personal.xls it will be.

From another workbook, you will need to use APplication.Run

Application.Run "Personal.xls!myMacro"

--
HTH

Bob Phillips

"jose luis" <jose.luis.1rrfas_1120673173.6089@excelforum-nospam.com> wrote
in message news:jose.luis.1rrfas_1120673173.6089@excelforum-nospam.com...
>
> Hi Josh, yes you have to have the otrher wb open in order to see the
> macros in the VBA Editor.
>
> Regards
> Jose Luis
>
>
> jhahes Wrote:
> > I saved a macro to the personal.xls option in macro recorder. How do I
> > access this from another workbook. Does the workbook I created the
> > macro in have to be open?
> >
> > Thanks for any help
> >
> > Josh
>
>
> --
> jose luis
> ------------------------------------------------------------------------
> jose luis's Profile:
http://www.excelforum.com/member.php...o&userid=13312
> View this thread: http://www.excelforum.com/showthread...hreadid=384972
>

Sorry Josh, I miss read the question , the answer Bob gave should keep you going.

Best Wishes

Jose Luis

Originally Posted by Bob Phillips

But if it is in Personal.xls it will be.

From another workbook, you will need to use APplication.Run

Application.Run "Personal.xls!myMacro"

--
HTH

Bob Phillips

"jose luis" <jose.luis.1rrfas_1120673173.6089@excelforum-nospam.com> wrote
in message news:jose.luis.1rrfas_1120673173.6089@excelforum-nospam.com...
>
> Hi Josh, yes you have to have the otrher wb open in order to see the
> macros in the VBA Editor.
>
> Regards
> Jose Luis
>
>
> jhahes Wrote:
> > I saved a macro to the personal.xls option in macro recorder. How do I
> > access this from another workbook. Does the workbook I created the
> > macro in have to be open?
> >
> > Thanks for any help
> >
> > Josh
>
>
> --
> jose luis
> ------------------------------------------------------------------------
> jose luis's Profile:
http://www.excelforum.com/member.php...o&userid=13312
> View this thread: http://www.excelforum.com/showthread...hreadid=384972
>