Ok, my problem is that my application has a function key which (should) go off to produce a report in the background. This report isn't to be printed but,when ready, is displayed on a spreadsheet control. In the meantime I would like the user to be able to carry on doing data-entry.
I've followed the coffee example in the VB documentation and also a couple of examples on this excellant website. However they all seem to depend on use of the timer control. When I ignore this and play around with the code to produce the report in the Active X exe my calling application still hangs whilst waiting for the exe to finish processing.
I can't set the ActiveX exe to run as unattended execution because it displays a form on completion of processing.
What I would like is the processing to carry on in the background and an event raised to signal that the report is ready to be displayed. How can I get this to happen?
My ActiveX exe is set up as Multiuse and the projecties are set to 'thread per object'.
Can anybody help?