where are personal.xls saved in o2k3?
 

Do a windows find for the file name

--
Don Guillett
SalesAid Software

"MBH" wrote in message
...

If you have one it will reside in

C:\Documents and Settings\username\Application\Data\Microsoft\Excel \XLSTART

Personal.xls is created the first time you record a Macro using Macro
Recorder.

ToolsMacroRecord New Macro. A dialog box will come up asking you name the
macro and where to place it. Pick Personal Macro Workbook from the dropdown.
Copy and paste a couple of cells then Stop Recording.

You now have a Personal.xls in your Office\XLSTART folder. You can go to
Visual Basic Editor(Alt+F11) to view the macro you just recorded in a Module.

You can add more macros by recording or by typing them into the Module.

You can do a FileSave from there or better yet hit ALT + Q to return to the
Excel window.

Then with Personal.xls active, hit WindowHide.

When you close Excel you will be asked if you want to save Personal.xls. Yes!

It will open hidden next time you start Excel.

Gord Dibben Excel MVP


On Thu, 27 Jan 2005 14:03:01 -0800, MBH wrote:

Limit the search to your documents and settings folder first. If not
found, then look everywhere -- under the mouse, etc. <g

Bill

"Don Guillett" wrote in message
...
Do a windows find for the file name

--
Don Guillett
SalesAid Software

"MBH" wrote in message
...

Providing there is no setting in ToolsOptionsGeneralAlternate start-up
folder they should be somewhere like

C:\Documents and Settings\[UserName]\Application
Data\Microsoft\Excel\XLStart

Bear in mind folders below the user name are hidden by default and
personal.xls will only exist if you have set one up or recorded a macro to
it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"MBH" wrote in message
...