ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   personal book will not open (https://www.excelbanter.com/excel-programming/356245-re-personal-book-will-not-open.html)

Tom Ogilvy

personal book will not open
 
You can't have two files with the same name in the same directory - so
something isn't as it seems. Find out where the personal.xls (that does
open) is located. Then close excel and replace that with your original.

--
Regards,
Tom Ogilvy



"Barb" wrote:

Hi
I have PERSONAL.xls in my C:\Documents and Settings\BMazur\Application
Data\Microsoft\Excel\XLSTART

When I open Excel my Personal book does not open and I can't get to my macros.
I deleted my old Personal book and started new one by recording a simple
macro. By doing that I created a new Personal book in my XLSTART, but it does
not open automaticaly. I thought everything in XLSTART opens automaticaly
when you start Excel.
Any sugestions?

Barb


Barb

personal book will not open
 
Hi Tom
Thanks for your reply. I don't have two Personal books there. In My XLSTART
I only have book.xlt and Personal.xls
I checked Genaral Options in book.xlt and "At startup open all files in" is
empty. I mapped it to XLSTART, but it does not save this folder address.
After I click OK on my options and go back to it it's still empty.

I'm puzzled.
Barb


"Tom Ogilvy" wrote:

You can't have two files with the same name in the same directory - so
something isn't as it seems. Find out where the personal.xls (that does
open) is located. Then close excel and replace that with your original.

--
Regards,
Tom Ogilvy



"Barb" wrote:

Hi
I have PERSONAL.xls in my C:\Documents and Settings\BMazur\Application
Data\Microsoft\Excel\XLSTART

When I open Excel my Personal book does not open and I can't get to my macros.
I deleted my old Personal book and started new one by recording a simple
macro. By doing that I created a new Personal book in my XLSTART, but it does
not open automaticaly. I thought everything in XLSTART opens automaticaly
when you start Excel.
Any sugestions?

Barb



All times are GMT +1. The time now is 02:45 PM.

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