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 wrote:
>
> 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
>
> --
> Zurn
> ------------------------------------------------------------------------
> Zurn's Profile: http://www.excelforum.com/member.php...o&userid=14645
> View this thread: http://www.excelforum.com/showthread...hreadid=534919

--

Dave Peterson

[Zurn]

Done, but everything OK in folder, I have the same StartupPath, and 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 when using Excel several times, at different moments I get the problem... I 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....

Zurn wrote:
>
> Done, but everything OK in folder, I have the same StartupPath, and
> 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 when
> using Excel several times, at different moments I get the problem... I
> searched forums, but no topics found.
>
> --
> Zurn
> ------------------------------------------------------------------------
> Zurn's Profile: http://www.excelforum.com/member.php...o&userid=14645
> View this thread: http://www.excelforum.com/showthread...hreadid=534919

--

Dave Peterson

[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 for "window" and "bring forward" . "window" should be the menu to the left of "help"

good luck

jocke

[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.

jocke wrote:
>
> 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 for
> "window" and "bring forward" . "window" should be the menu to the left
> of "help"
>
> good luck
>
> jocke
>
> --
> jocke
> ------------------------------------------------------------------------
> jocke's Profile: http://www.excelforum.com/member.php...nfo&userid=766
> View this thread: http://www.excelforum.com/showthread...hreadid=534919

--

Dave Peterson

[Zurn]

PERSONAL.XLS closes at irregular times.

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

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