Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about PERSONAL.XLS
Excel 2003. I was checking how many workbooks Excel thought were open, when
I only had one workbook open. Workbooks.Count returned 3. I checked what they we Workbooks(1).Name = PERSONAL.XLS Workbooks(2).Name = PERSONAL (version 1).xls Workbooks(3).Name = The workbook I have open Why do I have the PERSONAL.XLS opened, when I did not explicitly open it? Why are there two versions of PERSONAL.XLS open? How may I get rid of any or all of these "PERSONAL" workbooks? If I need to have one of them, then how do I get rid of the other (like the (version 1))? Thanks for the help. -- Dr. Doug Pruiett Good News Jail & Prison Ministry www.goodnewsjail.org |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about PERSONAL.XLS
Doug,
These are files in your XLStart directory that automatically open when Excel starts. They are opened as not visible, giving you a handy store for VBA code etc. If you don't want them Search in Windows Explorer and delete them. Or better still, move them first and see what you lose, and delete when you are happy. -- HTH Bob Phillips "Chaplain Doug" wrote in message ... Excel 2003. I was checking how many workbooks Excel thought were open, when I only had one workbook open. Workbooks.Count returned 3. I checked what they we Workbooks(1).Name = PERSONAL.XLS Workbooks(2).Name = PERSONAL (version 1).xls Workbooks(3).Name = The workbook I have open Why do I have the PERSONAL.XLS opened, when I did not explicitly open it? Why are there two versions of PERSONAL.XLS open? How may I get rid of any or all of these "PERSONAL" workbooks? If I need to have one of them, then how do I get rid of the other (like the (version 1))? Thanks for the help. -- Dr. Doug Pruiett Good News Jail & Prison Ministry www.goodnewsjail.org |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Personal.xls question | Excel Discussion (Misc queries) | |||
Personal macro workbook and personal.xls | Excel Discussion (Misc queries) | |||
personal.htm & personal.xls in Macro | Excel Programming | |||
Personal.xls Question | Excel Programming |