Personal.xls is an excel workbook that's usually stored in your XLStart folder.
If you don't do anything special, the first time it's created (and saved), it
will be a hidden workbook--so you may not notice it.
If you created the macro by recording your actions, you may have chosen
personal.xls in that first dialog. (There's a dropdown list asking where the
recorded macro should be stored.)
And lots of people use this personal.xls workbook to store macros that they want
available each time they open excel (hence the XLStart folder--you can find that
by using Windows start button|search and looking for XLStart).
Personal.xls is simply a workbook. Typically, it is located in
the XLStart folder (e.g., C:\Program Files\Microsoft
Office\Office\XLStart), and opened whenever you start Excel. One
usually stores in personal.xls macros that need to be available
all the time, regardless of what workbooks are open. There is
nothing special about personal.xls -- it is just another
workbook.
Being an old DOS programmer I like to think of Personal.XLS as my Global
function (macro) library for pieces of code that are reusable, as opposed to
code that is spreadsheet-specific and naturally lies within that specific
spreadsheet.
Being an old DOS programmer I like to think of Personal.XLS as my Global
function (macro) library for pieces of code that are reusable, as opposed to
code that is spreadsheet-specific and naturally lies within that specific
spreadsheet.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
