Hells guys/gals,
I have created different macros for different reports. i came across personal.xls
how to copy different macros in personal.xls file and after copying it to personal.xls how to use it in the new worksheet
Also, is personal.xls available in all windows edition

From another project, you need to qualify the macro with its workbook name,
like so

Application.Run "'Personal.xls'!Test"

If the macro has arguments, you use

Application.Run "'Personal.xls'!Test", "Goodbye"

Personal.xls is available in all Excel versions, but you don't have to call
it Personal.xls. You could create a workbook called Macro.xls if you wanted
and put your macros there, as long as it is in the XLStart directory. I am
not advocating that, just explaining what you can do.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"R. SRIKANTH" wrote in message
...
Hells guys/gals,
I have created different macros for different reports. i came across
personal.xls
how to copy different macros in personal.xls file and after copying it to
personal.xls how to use it in the new worksheet.
Also, is personal.xls available in all windows edition