F
F7772
how do I delete this file from the VBA editor? TIA
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
H
Hank Scorpio
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.
J
JE McGimpsey
Remove the file from your XLStart directory and restart XL.
F
F7772
nope, the XLStart folder is empty...
JE McGimpsey said:Remove the file from your XLStart directory and restart XL.
H
Hank Scorpio
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.
D
Dave Peterson
Make sure you check all your XLStart folders. Depending how you've upgraded,
you may have multiple XLStart folders.
you may have multiple XLStart folders.
D
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.
then type:
?workbooks("personal.xls").FullName
and hit enter. You'll see where this file is really located.