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?

Personal.XLS MACRO Workbook
 

Hi,
By default, Excel opens any book in the following directory upon startup.
Just place your book the
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?

Personal.XLS MACRO Workbook
 

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

Personal.XLS MACRO Workbook
 

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

Personal.XLS MACRO Workbook
 

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

Personal.XLS MACRO Workbook
 

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

Personal.XLS MACRO Workbook
 

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

Personal.XLS MACRO Workbook
 

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

Personal.XLS MACRO Workbook
 

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