Personal.xls
 

What does Personal.xls do? What is it?

Personal.xls
 

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).

John wrote:

What does Personal.xls do? What is it?

--

Dave Peterson

Personal.xls
 

John,

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.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"John" wrote in message
...
What does Personal.xls do? What is it?

Personal.xls
 

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.

"John" wrote:

What does Personal.xls do? What is it?

Personal.xls
 

Thanks to one and all

"DoctorG" wrote:

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.

"John" wrote:

What does Personal.xls do? What is it?

Personal.xls
 

Dave -

I have recorded a macro in my Excel 2003 personal.xls. Can I share this
macro with another user rather then re-recording the macro on her machine?

Thanks.....

"Dave Peterson" wrote:

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).

John wrote:

What does Personal.xls do? What is it?

--

Dave Peterson

Personal.xls
 

To share macros, you should put it in an addin, then install the addin on
all machines.


http://support.microsoft.com/default.aspx?kbid=211563
How to create an add-in file in Excel 2000


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Melissa" wrote in message
...
Dave -

I have recorded a macro in my Excel 2003 personal.xls. Can I share this
macro with another user rather then re-recording the macro on her machine?

Thanks.....

"Dave Peterson" wrote:

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).

John wrote:

What does Personal.xls do? What is it?

--

Dave Peterson

Personal.xls
 

I had a macro (a long one) saved in my Personal Macro Workbook, but it has
all of a sudden disappeared. Any idea why?

"Dave Peterson" wrote:

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).

John wrote:

What does Personal.xls do? What is it?

--

Dave Peterson

Personal.xls
 

Maybe you're opening the wrong workbook????

Maybe you've lost the complete file????



Gerry wrote:

I had a macro (a long one) saved in my Personal Macro Workbook, but it has
all of a sudden disappeared. Any idea why?

"Dave Peterson" wrote:

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).

John wrote:

What does Personal.xls do? What is it?

--

Dave Peterson


--

Dave Peterson