any idea to retrieve excel range values from background process?

**vijee** · 11-23-2006, 09:31 PM

Hi,
let me explain my task briefly, I have one excel spreadsheet which is connected to one external data source and retreiving live data from that and updating it every second.
I want to write one background process (i'm not sure, it can be a macro?) which collets data from my sheet and mail it to a recipient for every 15 mins.
i know, i can achieve this by writing macro within that worksheet.
but i would like to keep it seperate from my workbook, because some time any interruption to my worksheet causes macro stops running.

How to achive this without any interruption? and, that background process can be a macro wriiten in vba? Any help would be greatly appreciated!
Thanks.

**MattShoreson** · 11-24-2006, 07:40 AM

Could you not adapt the timer function?

Cycle for every 15mins whilst using a do events?

Msoft help file is as follows:

Timer Function Example
This example uses the Timer function to pause the application. The example also uses DoEvents to yield to other processes during the pause.

Dim PauseTime, Start, Finish, TotalTime
If (MsgBox("Press Yes to pause for 5 seconds", 4)) = vbYes Then
PauseTime = 5 ' Set duration.
Start = Timer ' Set start time.
Do While Timer < Start + PauseTime
DoEvents ' Yield to other processes.
Loop
Finish = Timer ' Set end time.
TotalTime = Finish - Start ' Calculate total time.
MsgBox "Paused for " & TotalTime & " seconds"
Else
End
End If