I am looking for a solution to handle from inside Lotus Notes with LotusScript events of distant OLE objects.
More precisely: how could I open an OLE connection for example to an Excel Spreadsheet and get/trap with LotusScript the click event on a button in the Excel Spreadsheet. In other words: How could I make my LotusScript in Lotus Notes react to the Button-Click event in the Excel Spreadsheet? LotusScript gives the opportunity to access properties and methods of OLE objects, but does it give the opportunity to handle/trap events of OLE objects?
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.
Dig deeper on LotusScript
Related Q&A from Todd Fuder
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.