Personal.XLS MACRO Workbook

How do I get Excel to open PERSONAL.XLS macro spreadhseet upon startup, and
have it reside in the background to make my MACROs available to all Excel
spreadsheets?

Hi,
By default, Excel opens any book in the following directory upon startup.
Just place your book there:
C:\Documents and Settings\<username>\Application Data\Microsoft\Excel\XLSTART
(Replace <username> with your login name)

You can choose a different directory in menu Tools > Options, tab General,
'Alternate Startup Directory'.

Regards,
Sebastien

"Don" wrote:

> How do I get Excel to open PERSONAL.XLS macro spreadhseet upon startup, and
> have it reside in the background to make my MACROs available to all Excel
> spreadsheets?

Yea, tried that, but doesn't work. It opens up an XLA file I have, but not
Personal.XLS. In fact, it opens any file EXCEPT personal.xls. Any ideas?

"sebastienm" wrote:

> Hi,
> By default, Excel opens any book in the following directory upon startup.
> Just place your book there:
> C:\Documents and Settings\<username>\Application Data\Microsoft\Excel\XLSTART
> (Replace <username> with your login name)
>
> You can choose a different directory in menu Tools > Options, tab General,
> 'Alternate Startup Directory'.
>
> Regards,
> Sebastien
>
> "Don" wrote:
>
> > How do I get Excel to open PERSONAL.XLS macro spreadhseet upon startup, and
> > have it reside in the background to make my MACROs available to all Excel
> > spreadsheets?

Could it be that the book is open then closed right away for some reasons?
To test, add a
msgbox "open"
in the Workbook_open sub of the ThisWorkbook module of the book.

Sebastien

"Don" wrote:

> Yea, tried that, but doesn't work. It opens up an XLA file I have, but not
> Personal.XLS. In fact, it opens any file EXCEPT personal.xls. Any ideas?
>
> "sebastienm" wrote:
>
> > Hi,
> > By default, Excel opens any book in the following directory upon startup.
> > Just place your book there:
> > C:\Documents and Settings\<username>\Application Data\Microsoft\Excel\XLSTART
> > (Replace <username> with your login name)
> >
> > You can choose a different directory in menu Tools > Options, tab General,
> > 'Alternate Startup Directory'.
> >
> > Regards,
> > Sebastien
> >
> > "Don" wrote:
> >
> > > How do I get Excel to open PERSONAL.XLS macro spreadhseet upon startup, and
> > > have it reside in the background to make my MACROs available to all Excel
> > > spreadsheets?

Works Now - all I did was create the sub:

Sub Workbook_open()
Msgbox "Open"
End Sub

in the This Workbook module,

then erased the sub. Seems to work.

I couldn't find any stray code anywhere that would have caused it to close.

Any ideas on a possible problem or why it misbehaved?

Thanks!
"sebastienm" wrote:

> Could it be that the book is open then closed right away for some reasons?
> To test, add a
> msgbox "open"
> in the Workbook_open sub of the ThisWorkbook module of the book.
>
> Sebastien
>
> "Don" wrote:
>
> > Yea, tried that, but doesn't work. It opens up an XLA file I have, but not
> > Personal.XLS. In fact, it opens any file EXCEPT personal.xls. Any ideas?
> >
> > "sebastienm" wrote:
> >
> > > Hi,
> > > By default, Excel opens any book in the following directory upon startup.
> > > Just place your book there:
> > > C:\Documents and Settings\<username>\Application Data\Microsoft\Excel\XLSTART
> > > (Replace <username> with your login name)
> > >
> > > You can choose a different directory in menu Tools > Options, tab General,
> > > 'Alternate Startup Directory'.
> > >
> > > Regards,
> > > Sebastien
> > >
> > > "Don" wrote:
> > >
> > > > How do I get Excel to open PERSONAL.XLS macro spreadhseet upon startup, and
> > > > have it reside in the background to make my MACROs available to all Excel
> > > > spreadsheets?

nope, no idea.
If there were some code somewhere closing the book right away, it should
still be there (even after your modif; like in an AutoOpen macro), so it
should continue to close right after being opened. And it s apparently not
the case. ...;No idea at all. Sorry.

Sebastien

"Don" wrote:

> Works Now - all I did was create the sub:
>
> Sub Workbook_open()
> Msgbox "Open"
> End Sub
>
> in the This Workbook module,
>
> then erased the sub. Seems to work.
>
> I couldn't find any stray code anywhere that would have caused it to close.
>
> Any ideas on a possible problem or why it misbehaved?
>
> Thanks!
> "sebastienm" wrote:
>
> > Could it be that the book is open then closed right away for some reasons?
> > To test, add a
> > msgbox "open"
> > in the Workbook_open sub of the ThisWorkbook module of the book.
> >
> > Sebastien
> >
> > "Don" wrote:
> >
> > > Yea, tried that, but doesn't work. It opens up an XLA file I have, but not
> > > Personal.XLS. In fact, it opens any file EXCEPT personal.xls. Any ideas?
> > >
> > > "sebastienm" wrote:
> > >
> > > > Hi,
> > > > By default, Excel opens any book in the following directory upon startup.
> > > > Just place your book there:
> > > > C:\Documents and Settings\<username>\Application Data\Microsoft\Excel\XLSTART
> > > > (Replace <username> with your login name)
> > > >
> > > > You can choose a different directory in menu Tools > Options, tab General,
> > > > 'Alternate Startup Directory'.
> > > >
> > > > Regards,
> > > > Sebastien
> > > >
> > > > "Don" wrote:
> > > >
> > > > > How do I get Excel to open PERSONAL.XLS macro spreadhseet upon startup, and
> > > > > have it reside in the background to make my MACROs available to all Excel
> > > > > spreadsheets?