Home |
Search |
Today's Posts |
#1
|
|||
|
|||
PERSONAL.XLS
how do I delete this file from the VBA editor? TIA
|
#2
|
|||
|
|||
On Sun, 24 Apr 2005 16:41:01 -0700, "F7772"
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! * |
#3
|
|||
|
|||
Remove the file from your XLStart directory and restart XL.
In article , "F7772" wrote: how do I delete this file from the VBA editor? TIA |
#4
|
|||
|
|||
nope, the XLStart folder is empty...
"JE McGimpsey" wrote: Remove the file from your XLStart directory and restart XL. In article , "F7772" wrote: how do I delete this file from the VBA editor? TIA |
#5
|
|||
|
|||
On Sun, 24 Apr 2005 17:24:02 -0700, "F7772"
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 , "F7772" 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! * |
#6
|
|||
|
|||
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 , "F7772" wrote: how do I delete this file from the VBA editor? TIA -- Dave Peterson |
#7
|
|||
|
|||
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 , "F7772" wrote: how do I delete this file from the VBA editor? TIA -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding Personal.xls Requires Exit Twice | Excel Worksheet Functions | |||
Where is Personal.Xls | Excel Discussion (Misc queries) | |||
Personal.xls | Excel Discussion (Misc queries) | |||
Personal.xls and Excel.xlb | Excel Discussion (Misc queries) | |||
personal.xls | Excel Worksheet Functions |