Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping an excel macro while it is running.
I have written a macro for a uni project. It takes in values from a GPS (location) and A/D converter (signa strangth). It records these values once a second in a loop. I want the user to be able to stop running this program whenever the have enough data. Please Help Me! Thankyou in advance.. -- Tigga ----------------------------------------------------------------------- Tiggaz's Profile: http://www.excelforum.com/member.php...fo&userid=1515 View this thread: http://www.excelforum.com/showthread.php?threadid=26782 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping an excel macro while it is running.
Hi,
I don't know what you are using to capture the GPS and A/D converter, but many of the industry ship software control and many as OLE Objects. Assuming some OLEObject were shipped, instead of looping in a vba loop and request values every second, you could a object, say oGPS that you would set to 1 second and the object would Tick every second. By capturing and processing the event only, there would be no loop and the user could continue to work or do whatever such as stopping the recording process. If you don't have such software, you could create a timer that only run the recording macro every second. See: http://www.cpearson.com/excel/ontime.htm Regards, Sebastien "Tiggaz" wrote: I have written a macro for a uni project. It takes in values from a GPS (location) and A/D converter (signal strangth). It records these values once a second in a loop. I want the user to be able to stop running this program whenever they have enough data. Please Help Me! Thankyou in advance... -- Tiggaz ------------------------------------------------------------------------ Tiggaz's Profile: http://www.excelforum.com/member.php...o&userid=15151 View this thread: http://www.excelforum.com/showthread...hreadid=267829 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stopping a Timer / Running a timer simultaneously on Excel | Excel Discussion (Misc queries) | |||
Stopping Excel macro pattern recgonition | New Users to Excel | |||
stopping macro | Excel Programming | |||
Stopping Excel after running visual basic in Access | Excel Programming | |||
My Macro keeps stopping?? | Excel Programming |