hi vishwakarma,

this is how i have a script set up to run daily at 7:30 am...

Control Panel>Scheduled Tasks>Add a Scheduled Task, and follow the wizard.
you don't need Application.Ontime.

all you need is this:
Private Sub Workbook_Open()
    Run "PullInSheet1"
End Sub

Sub PullInSheet1()
    'your code here
end sub
when your scheduled task runs, it will open your workbook and run PullInSheet1. after it's finished, your workbook will close.

you can schedule it to run as many times as you want.

i would like to see how a VBScript would be written. so if Bob is not too busy, maybe he can give an example...

zach