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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.