Problem solve Get help with specific problems with your technologies, process and projects.

Handle events of distant OLE objects inside Notes

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...