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?

Now I'm confused again. I insert the WorkBook_Open sub in all spreadsheets
under XLSTART, and they all respond - except for Personal.XLS. Could
something be preventing the workbook from openning? Maybe something coded as
an option in Excel?

"sebastienm" wrote:

> 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?

Now I'm confused - Personal.XLS refuses to open. Everything else under
XLSTART opens (verified by Workbook_open sub), but not personal.xls.

"sebastienm" wrote:

> 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?

The only thing i can think of right now is if a book/addin, that opens before
the Personal, sets the Application.EnableEvents to False. In that case, the
_Open of the personal wouldn't run. Such a property would be set through
code in one of these open addins/books. However, still, there some code that
closes the personal book, and you 've already looked into that and found
nothing.
The book could also be corrupted. Try to remove the book. create a new blank
one with just the Workbook_Open and a msgbox. Try this new one. Also try with
another name. Finally, if it work: Open the personal book and a blank book,
and in the vba ide, drag the code modules to the new book. Rename and save.

There is probably be some other explanation, but i don't see any right now.
Maybe someelse will have a better idea.

Regards,
Sebastien

I AM THOROUGHLY LOST. I open up the Personal.XLS through the WorkBook_Open
sub in Book1, and it seemed to work for a while. Now, the MACRO icons refer
to a file name I used just to get the things to work, and will not accept
assignment fo any MACRO under Personal.XLS. I try assigning it to a MACRO
under Personal.xls (and yes, the MACRO is available - I check it out under
Tools>MACROs>Visual Basic Editor)

Could there be a security setting that screws things up? I'm puzzled at the
randomness of this problem. Whe trying to assign a MACRO to an icon, they
all show, but refuse to be assigned.

"sebastienm" wrote:

> The only thing i can think of right now is if a book/addin, that opens before
> the Personal, sets the Application.EnableEvents to False. In that case, the
> _Open of the personal wouldn't run. Such a property would be set through
> code in one of these open addins/books. However, still, there some code that
> closes the personal book, and you 've already looked into that and found
> nothing.
> The book could also be corrupted. Try to remove the book. create a new blank
> one with just the Workbook_Open and a msgbox. Try this new one. Also try with
> another name. Finally, if it work: Open the personal book and a blank book,
> and in the vba ide, drag the code modules to the new book. Rename and save.
>
> There is probably be some other explanation, but i don't see any right now.
> Maybe someelse will have a better idea.
>
> Regards,
> Sebastien

Ok - I deleted everything (after exporting the MACRO modules), even the Book1
files, etc. Openned up Excel, which finally created Book1, entered Visual
Basic Editor, imported Module 1 (which consists only of comments), and saved
as Personal.XLS in XLSTART. Closed Excel, and re-oppened it - NO
PERSONAL.XLS. Renamed Personal.XLS to Personals.XLS, and Success!. Why
doesn't Excel like Personal.XLS?

"sebastienm" wrote:

> The only thing i can think of right now is if a book/addin, that opens before
> the Personal, sets the Application.EnableEvents to False. In that case, the
> _Open of the personal wouldn't run. Such a property would be set through
> code in one of these open addins/books. However, still, there some code that
> closes the personal book, and you 've already looked into that and found
> nothing.
> The book could also be corrupted. Try to remove the book. create a new blank
> one with just the Workbook_Open and a msgbox. Try this new one. Also try with
> another name. Finally, if it work: Open the personal book and a blank book,
> and in the vba ide, drag the code modules to the new book. Rename and save.
>
> There is probably be some other explanation, but i don't see any right now.
> Maybe someelse will have a better idea.
>
> Regards,
> Sebastien