personal.xls

  • Thread starter Pat-southern-California
  • Start date
P

Pat-southern-California

I want to get rid of personal.xls. I don't need the macro. Personal is not
hidden but I cannot get to it. I went into XLStartup, not there either.

I noticed a posting from 2004 said "delete it." I wish I could.

Pat from southern California.
 
V

Vasant Nanavati

Do a Windows search for it and delete it, if you have such strong feelings
against it. <g>
_________________________________________________________________________
 
D

Dave Peterson

Open excel
Hit alt-f11 to get to the VBE
Hit ctrl-r to see the project explorer
verify that personal.xls appears in that window.

Hit ctrl-g to get to the immediate window
type this and hit enter:
?workbooks("personal.xls").path

You'll see the path displayed in that immediate window.
Copy that string

hit flying-windows-key-r to see the windows Run dialog.
(windows start button|run will work under some versions of windows)

Paste that into that run dialog
Windows explorer should open so you can the contents of that folder.

Do you see personal.xls?

If yes, then back to excel and close excel
(You won't be able to delete personal.xls if it's in use by excel)

Delete it (or move it to an out of the way location until you're sure you want
to delete it).
 
V

Vasant Nanavati

I like my method better. It works even if personal.xls is not open. <g>
________________________________________________________________________
 
T

T. Valko

When you say "Personal is not hidden", what exactly do you mean?

Normally, it's a *hidden file* in the XLStart directory and it opens as a
*hidden workbook* when you start Excel. So, which of those "not hiddens" are
you referring to?

You need to set your folder options to display hidden files and directories
then you'll probably find it in the XLStart directory where you can delete
it.
 
V

Vasant Nanavati

Biff, congratulations! July 1?
_________________________________________________________________________
 
D

driller

sorry to interrupt,

What's the main objective of the personal.xls in excellation...? before and
now..


regards,
driller
 
V

Vasant Nanavati

Yeah, real life got in the way, etc. But hoping to get up to speed soon and
contribute regularly. :)
___________________________________________________________________________
 
T

T. Valko

When you have macros and want those macros to be available to any workbook
you open, you store them in a file called Personal.xls which is stored in
the XLStart directory. The Personal.xls file opens as a hidden workbook when
you start Excel. This file doesn't exist until you create it by recording a
macro (or you could do it all manually). When you start the macro recorder
you're presented with a dialog box asking you where you want to store the
macro you're about to create.

For example, I do a lot of testing and need to generate lots of random
numbers all the time. So I have a macro that generates these random numbers.
I need to have this available to any file I'm working on so I store this
macro in Personal.xls. I added a custom button to one of my toolbars and
then assigned that macro to that button. This saves me a lot of time and I
don't have to fool around writing a bunch of RAND/RANDBETWEEN functions (and
their volatility).
 
D

Dave Peterson

Lots of people have trouble using windows|search--especially finding files that
may be in hidden folders.

Shelling to DOS and doing
Dir C:\ personal.xl* /s

seems to help find files that windows|search (with the wrong settings) won't
find.

(What I'm trying to say is: I like mine better! <vbg>)
 
P

Pat-southern-California

I would keep it, but I have to share the doc with others who feel it is
'confusing' and - well, they fight any feature I suggest tooth and nail.
They don't even like a suggestion of using absolutes or anything that would
take them, kicking and screeming into the 21st century.

When I taught MS Applications, many people were hesitant to use features
because they were used to manually doing so many things.

Thanks for this info, I could not remember how to get rid of that 'pesky'
feature!
 
P

Pat-southern-California

I do wish I were more versed in VBE. I have not been keeping up to date on
it and have not had the time to work on it. I can see your method will work
well and will keep a copy in my "stuff" file.

My stuff file is full of things I refer to all the time with great enthusiasm!

Thanks so much, Pat
 
D

Dave Peterson

Personal.xls is usually a file that isn't shared with others.

Are you sure you're not just sharing a plain old data workbook with others. If
you are, then you having personal.xls on your pc should affect the others at
all.
 
Top