Identify Document Being opened from an Add-In using Auto_Open?

[Yo]

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.

 

[Chip Pearson]

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]

Thanks,
Works like a charm!

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