View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
J.E. McGimpsey J.E. McGimpsey is offline
external usenet poster
 
Posts: 493
Default saving in CSV format ... every 10 seconds

Take a look at

http://cpearson.com/excel/ontime.htm

In article ,
"jon" wrote:

I have some data in the activeSheet that I want to automatically save every
10 seconds in CSV format so as to do some processing with it
I have review function TIMER and a DO WHILE to do this task but I am not
sure that this would be the best way
thanks,