ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   controlling from xls , word events (https://www.excelbanter.com/excel-programming/310434-controlling-xls-word-events.html)

jlsainz

controlling from xls , word events
 

hello, I have some problems to control the event documents.close for
excel.
I know that I have to use Withevents in the module class,

Public withevents APPWord as application ; why as application?

Private sub APP_Word.Application.Beforeclose (......)

Where and whend I have to define the Word application, in th
thisworkbook module or in the class module?

am I in the right way?

thaks, and sorry, I'm not englis

--
jlsain
-----------------------------------------------------------------------
jlsainz's Profile: http://www.excelforum.com/member.php...fo&userid=1450
View this thread: http://www.excelforum.com/showthread.php?threadid=26133



All times are GMT +1. The time now is 03:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com