Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. articles. downloads. faq. members. files. rss.
 From: Yousfi Benameur
  Where is Yousfi Benameur?
 El Bayadh
 Algeria
 Yousfi Benameur
Subject: Monitoring excel
Thread ID: 187364 Message ID: 187364 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Active X Controls & OLE Automation
Date: Sunday, August 3, 2008 5:00:37 PM         
   



Hi all
I write a small code for monitoring an excel window.
From a form ,i create an object oExcel (public) with createobject ,put a timer (interval=100 ms) and test in the timer event: If the excel window diseappear, i output a messagebox.

if vartype(oExcel)#"O" or isnull(oExcel)
messagebox("Excel was closed!",0+32+4096)
else
wait window("oExcel  lives yet...!") nowait
endi


I close manually excel but the timer not see anything and continous to monitoring .....believe oExcel lives yet.

Who is wrong ?
I solve this question by the excel title (see the thread N°186837)

ENTIRE THREAD

Monitoring excel Posted by Yousfi Benameur @ 8/3/2008 5:00:37 PM
RE: Monitoring excel Posted by Borislav Borissov @ 8/3/2008 5:12:59 PM
RE: Monitoring excel Posted by Yousfi Benameur @ 8/3/2008 5:54:53 PM
RE: Monitoring excel Posted by Borislav Borissov @ 8/3/2008 6:43:13 PM
RE: Monitoring excel Posted by Anders Altberg @ 8/3/2008 7:26:04 PM
RE: Monitoring excel Posted by Yousfi Benameur @ 8/3/2008 7:59:25 PM
RE: Monitoring excel Posted by Borislav Borissov @ 8/3/2008 8:18:47 PM
RE: Monitoring excel Posted by Yousfi Benameur @ 8/3/2008 9:19:20 PM