Personal.xls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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
Click to expand...
personal.xls how to use it in the new worksheet.
 
Back
Top