PERSONAL.XLS

how do I delete this file from the VBA editor? TIA

On Sun, 24 Apr 2005 16:41:01 -0700, "F7772"
<F7772@discussions.microsoft.com> wrote:

>how do I delete this file from the VBA editor? TIA

Personal.xls is loaded automatically from the xlStart folder, the
location of which will vary according to your operating system and
Office version. All you need to do is find that folder, and move
personal.xls out of it.

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *

Remove the file from your XLStart directory and restart XL.

In article <4B836B29-2334-4A54-BB1A-922F0F568C92@microsoft.com>,
"F7772" <F7772@discussions.microsoft.com> wrote:

> how do I delete this file from the VBA editor? TIA

nope, the XLStart folder is empty...

"JE McGimpsey" wrote:

> Remove the file from your XLStart directory and restart XL.
>
> In article <4B836B29-2334-4A54-BB1A-922F0F568C92@microsoft.com>,
> "F7772" <F7772@discussions.microsoft.com> wrote:
>
> > how do I delete this file from the VBA editor? TIA
>

On Sun, 24 Apr 2005 17:24:02 -0700, "F7772"
<F7772@discussions.microsoft.com> wrote:

>nope, the XLStart folder is empty...

Are you sure that you found the right one? The location of the folder
has changed over the versions and some old directories could well have
been left behind if you upgraded.

Alternatively, check Tools -> Options -> General, and see whether
there's an alternative "At startup, open all files in..." directory.
If so, see whether the file is in that one.

>"JE McGimpsey" wrote:
>
>> Remove the file from your XLStart directory and restart XL.
>>
>> In article <4B836B29-2334-4A54-BB1A-922F0F568C92@microsoft.com>,
>> "F7772" <F7772@discussions.microsoft.com> wrote:
>>
>> > how do I delete this file from the VBA editor? TIA



---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *

Make sure you check all your XLStart folders. Depending how you've upgraded,
you may have multiple XLStart folders.

F7772 wrote:
>
> nope, the XLStart folder is empty...
>
> "JE McGimpsey" wrote:
>
> > Remove the file from your XLStart directory and restart XL.
> >
> > In article <4B836B29-2334-4A54-BB1A-922F0F568C92@microsoft.com>,
> > "F7772" <F7772@discussions.microsoft.com> wrote:
> >
> > > how do I delete this file from the VBA editor? TIA
> >

--

Dave Peterson

In fact, next time you're in the VBE, hit ctrl-g (to see the immediate window)
then type:
?workbooks("personal.xls").FullName

and hit enter. You'll see where this file is really located.

F7772 wrote:
>
> nope, the XLStart folder is empty...
>
> "JE McGimpsey" wrote:
>
> > Remove the file from your XLStart directory and restart XL.
> >
> > In article <4B836B29-2334-4A54-BB1A-922F0F568C92@microsoft.com>,
> > "F7772" <F7772@discussions.microsoft.com> wrote:
> >
> > > how do I delete this file from the VBA editor? TIA
> >

--

Dave Peterson