Hey everyone, I am curious to know whether or not it is possible to use a script to listen to listen for an event. To be more specific I am trying to monitor Excel for certain events to take place, and when they do I need to write data to a port over a remote server. My first thought is to run the script using a Do While loop to check for events. Running the script in a loop in the background shouldn't be that much of a performance hog (at least I don't think) because I'm running a beast of a machine. Plus the script is running on it's own thread so I'm hoping that making it loop in the background won't have performance issues. (If you think otherwise please let me know).
The other issue I'm concerned with however is that while the script "listens" for an event in Excel by handling the application object;
Using that Instance of Excel (to initiate the event) might make the script crash. I have experienced this before while using scripts to handle processing in Excel where while it was writing data to the sheet I couldn't click in a cell otherwise the script would crash.
Dim objExcel as Object = ("Excel.Application")
I can't compile executable files or use VSTO unfortunately because of work restrictions. I am however given permission to run a certain scripting environment.