ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Question about PERSONAL.XLS (https://www.excelbanter.com/excel-programming/329472-question-about-personal-xls.html)

Chaplain Doug

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

Bob Phillips[_7_]

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





All times are GMT +1. The time now is 06:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com