Macro Recorder

[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

 

[jose luis]

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

Regards
Jose Luis

 

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

 

[jose luis]

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

Best Wishes

Jose Luis