software

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
Helpgt;About Microsoft Office Helpgt;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?ThanksZurn--
Zurn
------------------------------------------------------------------------
Zurn's Profile: www.excelforum.com/member.php...oamp;userid=14645
View this thread: www.excelforum.com/showthread...hreadid=534919Just 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\XLSTARTMaybe things aren't where they're supposed to be.

Zurn wrote:
gt;
gt; Hello,
gt;
gt; it happens that I 've lost my PERSONAL.xls folder in my VBA editor. In
gt; the personal.xls, there is code that should run at startup of each
gt; excel (xls, csv, xlt, ...)
gt;
gt; What causes this?
gt;
gt; Looking at
gt; Helpgt;About Microsoft Office Helpgt;Disabled Items... is empty
gt;
gt; Going to XLStart folder and opening PERSONAL.xls does the job. But I
gt; don't want to do this everytime the Personal.xls is gone.
gt;
gt; Cause? Solution?
gt;
gt; Thanks
gt;
gt; Zurn
gt;
gt; --
gt; Zurn
gt; ------------------------------------------------------------------------
gt; Zurn's Profile: www.excelforum.com/member.php...oamp;userid=14645
gt; View this thread: 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: www.excelforum.com/member.php...oamp;userid=14645
View this thread: www.excelforum.com/showthread...hreadid=534919This 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:
gt;
gt; Done, but everything OK in folder, I have the same StartupPath, and
gt; files are in it...
gt;
gt; PERSONAL.XLS is in correct folder but not starting up.
gt;
gt; Very strange, and I don't have this when I restart Windows. Then when
gt; using Excel several times, at different moments I get the problem... I
gt; searched forums, but no topics found.
gt;
gt; --
gt; Zurn
gt; ------------------------------------------------------------------------
gt; Zurn's Profile: www.excelforum.com/member.php...oamp;userid=14645
gt; View this thread: 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 quot;personal.xlsquot;
then choose quot;windowquot;, choose quot;bring forwardquot;
then personal.xls should be visible.

my exel isn't in english so i might have have the wrong words for
quot;windowquot; and quot;bring forwardquot; . quot;windowquot; should be the menu to the left
of quot;helpquot;

good luck

jocke--
jocke
------------------------------------------------------------------------
jocke's Profile: www.excelforum.com/member.php...nfoamp;userid=766
View this thread: www.excelforum.com/showthread...hreadid=534919The OP said that the personal.xls project was gone from the VBE (project
explorer).

I bet that the workbook isn't open.

jocke wrote:
gt;
gt; hi try this to bring personal.xls to visible
gt;
gt; record a macro, just anything, save it in quot;personal.xlsquot;
gt; then choose quot;windowquot;, choose quot;bring forwardquot;
gt; then personal.xls should be visible.
gt;
gt; my exel isn't in english so i might have have the wrong words for
gt; quot;windowquot; and quot;bring forwardquot; . quot;windowquot; should be the menu to the left
gt; of quot;helpquot;
gt;
gt; good luck
gt;
gt; jocke
gt;
gt; --
gt; jocke
gt; ------------------------------------------------------------------------
gt; jocke's Profile: www.excelforum.com/member.php...nfoamp;userid=766
gt; View this thread: www.excelforum.com/showthread...hreadid=534919

--

Dave Peterson


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