how do you generate a report every 5 mins automatically and delete
 

I am designing an application in excel which can generate a report by copying
data from a different application and comparing it every 5 mins to check if
any data has been changed in specific fields and if any data has been changed
alert the user and the action should be started by the double click event in
excel . How do we do the programming in excel 2002 ?

how do you generate a report every 5 mins automatically and delete
 

You might be better off using a WorkSheet_Change event to notfy users each
time the values of specified cells change.

Regards
Rowan

"SwitchBrain" wrote:

I am designing an application in excel which can generate a report by copying
data from a different application and comparing it every 5 mins to check if
any data has been changed in specific fields and if any data has been changed
alert the user and the action should be started by the double click event in
excel . How do we do the programming in excel 2002 ?