PERSONAL.XLS

  • Thread starter Thread starter Guest
  • Start date Start date
how do I delete this file from the VBA editor? TIA
Click to expand...

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.
 
nope, the XLStart folder is empty...
Click to expand...

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.
 
Make sure you check all your XLStart folders. Depending how you've upgraded,
you may have multiple XLStart folders.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Personal.xls gone 6
How do I remove VBA projects in Excel 4
personal.xls 2
Toolbar - Button Won't Stay 3
VBA to capture (print or list) names of all Sub's or Function macro's in Personal.xls 7
Two Personal.xls Files 2
Personal.XLS is locked for editing. How to unlock it? 1
Stop Symantec AV from quarantine my VBA 4

Back
Top