windows task scheduler

Hello everybody, I have what I assumed was a pretty simple code, but for some reason it keeps rerunning, so perhaps there is an error in my code, or maybe just a smarter way to go about doing this. Here is the This workbook code: Private Sub Workbook_Open() Application.Visible = False...

Hey all. I am currently weiting a program that automatically runs at 6am using task scheduler. It is to make a range of data from sheet 1 and save it as an image (i am currently doing this with the chart.add method). I have found that it works fine when I am logged into my username. What i am...

Hello, I have created a database that I would like to put on a schedule to send out every day without manual intervention. I have seen a lot of posts from various websites about using Windows Task Scheduler. I cannot figure out how to use the Windows Task Scheduler. I was coming here either for...

Hello, I keep getting this windows script host error. Script: C\top 5 macro.vbs Line: 5 Char: 1 Error: Unknown runtime error Code: 800A9C68 Source: Microsoft VBScript runtime error Dim xlApp Dim xlBook Set xlApp = CreateObject("Excel.Application") Set xlBook =...

I have a macro that runs on the second to last business day of each month. The macro pulls down data from two of our TM1 cubes and does a variance check to make sure everything is in sync. The macro works great using Private Sub Workbook_Open() and it is coupled with windows task scheduler...