oinkl
12-27-2010, 01:33 AM
Is it possible for the fields in my application to automatically update when it receives some notification message?
The message is a JMS message received by a Java application running in a background thread. When the Java app receives the message, it does some processing and sends some data to my Excel spreadsheet. The spreadsheet is then supposed to automatically update based on this data. Can I register some sort of listener in VBA to listen for this message?
Thanks.
[edit] Or alternatively, is it possible to continually poll some location/file at regular intervals to check for updates?
The message is a JMS message received by a Java application running in a background thread. When the Java app receives the message, it does some processing and sends some data to my Excel spreadsheet. The spreadsheet is then supposed to automatically update based on this data. Can I register some sort of listener in VBA to listen for this message?
Thanks.
[edit] Or alternatively, is it possible to continually poll some location/file at regular intervals to check for updates?