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
HelpAbout Microsoft Office HelpDisabled 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

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
HelpAbout Microsoft Office HelpDisabled 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

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

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

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

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