Add-in crashes Excel
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 |
Add-in crashes Excel
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 |
Add-in crashes Excel
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 |
Add-in crashes Excel
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 |
All times are GMT +1. The time now is 01:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com