Personal.xls gone

[Zurn]

Hello,

it happens that I 've lost my PERSONAL.xls folder in my VBA editor. In
the personal.xls, there is code that should run at startup of each
excel (xls, csv, xlt, ...)

What causes this?

Looking at
Help>About Microsoft Office Help>Disabled Items... is empty

Going to XLStart folder and opening PERSONAL.xls does the job. But I
don't want to do this everytime the Personal.xls is gone.

Cause? Solution?


Thanks


Zurn

 

[Dave Peterson]

Just a guess....

I'd check to see if your personal.xls is in the correct XLStart folder.

Start excel
open the VBE (alt-f11)
hit ctrl-g (to see the immediate window)

type this and hit enter.
?application.startuppath

For me (xl2003 and winXP):
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART


Maybe things aren't where they're supposed to be.

 

[Zurn]

Done, but everything OK in folder, I have the same StartupPath, an
files are in it...

PERSONAL.XLS is in correct folder but not starting up.



Very strange, and I don't have this when I restart Windows. Then whe
using Excel several times, at different moments I get the problem...
searched forums, but no topics found

 

[Dave Peterson]

This doesn't sound possible, but....

Any chance that you're starting up different instances of excel and by chance
you're dismissing the prompt that tells you that personal.xls is in use, do you
want to open it readonly (instead of answering to open it readonly)????

And how are you starting up excel? Just clicking on an excel icon or a workbook
or through some other mechanized routine?

Can you keep track of how you start excel and when personal.xls doesn't appear
to see if you can see a pattern?

(and you did double check that disabled items list, right?)

Yeah, I don't have any good guesses....

 

[jocke]

hi try this to bring personal.xls to visible

record a macro, just anything, save it in "personal.xls"
then choose "window", choose "bring forward"
then personal.xls should be visible.

my exel isn't in english so i might have have the wrong words fo
"window" and "bring forward" . "window" should be the menu to the lef
of "help"

good luck

jock

 

[Dave Peterson]

The OP said that the personal.xls project was gone from the VBE (project
explorer).

I bet that the workbook isn't open.

 

[Zurn]

PERSONAL.XLS closes at irregular times.

Now I have a Shortcut on my desktop to open PERSONAL.XLS when I los
it.

What I see is that a Software tool I use, sometimes 'uses' excel.
allready contacted the provider and devellopment department. I hope th
cause is located on their level