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


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=384972

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

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" wrote
in message ...

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


Bob Phillips Wrote:
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"
wrote
in message
...

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



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