|
There is an OnEvent method defined in Notes' LotusScript that allows you to design custom event handlers, but it is only available for Lotus native events (those defined within Notes). However, I have two suggested workarounds:
1. Have Excel perform Automation on Notes when the event fires in Excel.
Just have Excel perform an OLE automation (contacting Notes, performing whatever event handler you want, closing the connection to Notes).
2. Have Excel write something to a text file on the hard drive that Notes hangs around looking for (using the NotesTimer object), and performs the event handler code in Notes when it sees that item appear on the hard drive (have it check every second or something).
Personally, I like the first choice -- I think it's cleaner and neater (and cooler). But I haven't tried it between Notes and Excel. I have done something similar a long time ago between WordPro and Notes, and it worked pretty well.
|
