Running a macro at a certain time

Hot Topic

Using arrows to select in drop down list in access
Lack of mouse scroll wheel support in VBA
vlookup
Completly Lost with Data Validation Code
ScreenUpdating
Restrict editing of activity based on date comparison
Gantt Chart component/library
vba array?
Right-click menu icon
vlookup

Microsoft ISV

Newbie Help: All caps to Title caps
Challenge writing a macro for setting Mergefields properties
I want to create a "search" engine within my Excel spreadsheet.
worksheet_change and data validation
vlookup
Action Pack Question
what is wrong with this formula? *9 Views & no one knows?*
excel load event
How to change line within one statement?
IIf function within MS Access

Running a macro at a certain time

I would like to have a macro that automatically runs once every day at a certain time. Is this possible and does Excel and the spreadsheet need to be open in order for the macro to execute Any help is appreciated!

Answer this question

Running a macro at a certain time

  • vitich

    I would use the windows scheduler to open the Excel Spreadsheet at the designated intervals and have an auto-run macro setup so that every time the sheet is open your macro executes

  • Rocket horse

    If your macro is in a spreadsheet then Excel needs to be open in order to run it. If you don't want to do this then you could maybe create a vbscript file instead (look up scripting). You could then maybe run this by scheduling a task Programs->Accessories->System Tools->Scheduled Tasks.

  • Quilnux

    Ok thanks alot!! Last question I hope,

    do you have to be logged in to Windows in order for this to work The computer is on at all times but at night when I had planned to let the macro execute no one is logged on to the computer. Would be very grateful for your help! Thank you very much for your answers!!
  • Running a macro at a certain time
Answer this question