Hi everyone.

I have inherited an add-in that has to be always-on , on my users' machines.
It also need to do some stuff in its Auto_Open sub.

Trouble is, if I don't include:

Application.Workbooks.Add

in the Auto-Open code I get an Excel crash (Excel 2003, Windows XP). And
some of my users want to open Excel (and the add-in) but without a blank
workbook appearing.

Any ideas? Is it imperitive for Excel to have a blank workbook when it first
opens? Is this an Excel setting somewhere?

TIA,
big t

You should write the add in such that it does not require a
workbook to be open.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"big t" wrote in message
...
Hi everyone.

I have inherited an add-in that has to be always-on , on my
users' machines.
It also need to do some stuff in its Auto_Open sub.

Trouble is, if I don't include:

Application.Workbooks.Add

in the Auto-Open code I get an Excel crash (Excel 2003, Windows
XP). And
some of my users want to open Excel (and the add-in) but
without a blank
workbook appearing.

Any ideas? Is it imperitive for Excel to have a blank workbook
when it first
opens? Is this an Excel setting somewhere?

TIA,
big t

The add-in doesn't require a workbook to be open. It just seems that if I
don't open one I get the Excel crash!

cheers
big t


"Chip Pearson" wrote:

You should write the add in such that it does not require a
workbook to be open.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"big t" wrote in message
...
Hi everyone.

I have inherited an add-in that has to be always-on , on my
users' machines.
It also need to do some stuff in its Auto_Open sub.

Trouble is, if I don't include:

Application.Workbooks.Add

in the Auto-Open code I get an Excel crash (Excel 2003, Windows
XP). And
some of my users want to open Excel (and the add-in) but
without a blank
workbook appearing.

Any ideas? Is it imperitive for Excel to have a blank workbook
when it first
opens? Is this an Excel setting somewhere?

TIA,
big t

It sounds like you are executing commands in your addin open event that
require that a workbook be open. You would have to eliminate these
commands. Perhaps perform them when a workbook is open.

--
Regards,
Tom Ogilvy

"big t" wrote in message
...
The add-in doesn't require a workbook to be open. It just seems that if I
don't open one I get the Excel crash!

cheers
big t


"Chip Pearson" wrote:

You should write the add in such that it does not require a
workbook to be open.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"big t" wrote in message
...
Hi everyone.

I have inherited an add-in that has to be always-on , on my
users' machines.
It also need to do some stuff in its Auto_Open sub.

Trouble is, if I don't include:

Application.Workbooks.Add

in the Auto-Open code I get an Excel crash (Excel 2003, Windows
XP). And
some of my users want to open Excel (and the add-in) but
without a blank
workbook appearing.

Any ideas? Is it imperitive for Excel to have a blank workbook
when it first
opens? Is this an Excel setting somewhere?

TIA,
big t