What is Personal.xls

  • Thread starter Thread starter Nathalie
  • Start date Start date
N

Nathalie

What exactly is the personal.xls file? I created the macro to create the
file as a test (I'm always testing something to see if I can make it work)
and now it opens with every excel file. I know I can delete it, but what is
it used for?

Thanks!
 
When you start recording a macro, Excel asks where you want to store it.
Your three choices are: current workbook, a fresh workbook, or your personal
workbook. Personal.xls is the last choice; it's a single place to collect
all your VBA code so it's available whenever you start Excel.
--
HTH -

-Frank
Microsoft Excel MVP
Dolphin Technology Corp.
http://vbapro.com
 
Thanks Frank.

Frank Isaacs said:
When you start recording a macro, Excel asks where you want to store it.
Your three choices are: current workbook, a fresh workbook, or your personal
workbook. Personal.xls is the last choice; it's a single place to collect
all your VBA code so it's available whenever you start Excel.
--
HTH -

-Frank
Microsoft Excel MVP
Dolphin Technology Corp.
http://vbapro.com


what
Click to expand...
 
Back
Top