| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identify Document Being opened from an Add-In using Auto_Open?
I would like to use the Module inside an Add-In to identify the worksheet
name of the workbook being opened. I tried to use the Auto_Open to query the name of the activedocument, and found out that this event happens before the workbook actually opens. How do I run a code immediatly after the workbook has been activated? Thanks in advance, Yo. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Identify Document Being opened from an Add-In using Auto_Open?
You need to use application events to trap for workbook being
opened. See www.cpearson.com/excel/appevent.htm for more details. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Yo" wrote in message ... I would like to use the Module inside an Add-In to identify the worksheet name of the workbook being opened. I tried to use the Auto_Open to query the name of the activedocument, and found out that this event happens before the workbook actually opens. How do I run a code immediatly after the workbook has been activated? Thanks in advance, Yo. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Identify Document Being opened from an Add-In using Auto_Open?
Thanks,
Works like a charm! "Chip Pearson" wrote in message ... You need to use application events to trap for workbook being opened. See www.cpearson.com/excel/appevent.htm for more details. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Yo" wrote in message ... I would like to use the Module inside an Add-In to identify the worksheet name of the workbook being opened. I tried to use the Auto_Open to query the name of the activedocument, and found out that this event happens before the workbook actually opens. How do I run a code immediatly after the workbook has been activated? Thanks in advance, Yo. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identify the network path a file was opened from (Excel2007) | Excel Discussion (Misc queries) | |||
| Saved Changes Gone Next Time Document is Opened | Excel Discussion (Misc queries) | |||
| Excel Menus don't function when document opened in IE6 | Excel Discussion (Misc queries) | |||
| Document already opened in excel | Excel Discussion (Misc queries) | |||
| Auto_Open not running when file opened normally | Excel Programming | |||
Linear Mode
