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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
You might be better off using a WorkSheet_Change event to notfy users each
time the values of specified cells change.

Regards
Rowan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding a "Min" value 5
Running a Macro periodically between Time A and Time B 7
How do I generate a report in Excel? 2
Exceptional and Detachable Batteries - AORUS 5 Gaming Laptop Unboxing 3
How to calculate a Max / min in a matrix 1
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
auto refresh excel 1
Can't create a report from my query in Access 1

Back
Top