store data in next worksheet at certain time

[mirzao]

Hi,
I have an application to collect data and store it into an excel file. But I don't know how to change into another worksheet. I want the application to start with another worksheet at 2pm, 10 pm and 6am.anyone have any experience on this? Thanks

 

[JohnH]

If you mean you got three sheets you want to use interchangably at certain times, you .Activate method on the sheet:
http://msdn.microsoft.com/library/en-us/vbaxl11/html/xlobjWorksheet1_HV05206015.asp

If you want to add a new sheet at these intervals, then use the Add method of the Sheets collection:
http://msdn.microsoft.com/library/en-us/vbaxl11/html/xlobjSheets1_HV05205046.asp