如何无需打开Excel文件或VBA宏，每日定时运行指定VBA宏？

Hey James, totally get where you’re coming from—wanting to automate that daily VBA macro run without having to manually open Excel every single time is such a time-saver. Let me walk you through the most reliable way to do this using built-in Windows tools, no fancy software required.

First, we’ll make a simple VBS (Visual Basic Script) file that tells Excel to open your workbook, run the macro, and clean up afterward. Here’s how:

1. Right-click on your desktop (or any folder) → New → Text Document.
2. Rename it to something like RunDailyMacro.vbs (make sure you change the file extension from .txt to .vbs—you might need to enable "File name extensions" in File Explorer to do this).
3. Open the file with Notepad and paste this code, then tweak the details to match your setup:

' Create an Excel object
Set objExcel = CreateObject("Excel.Application")
' Keep Excel hidden so it runs in the background
objExcel.Visible = False

' Open your workbook - replace the path with your actual file location
Set objWorkbook = objExcel.Workbooks.Open("C:\Your\Full\Path\To\Workbook.xlsm")

' Run your macro - adjust the name here. If it's in a worksheet module, use "Sheet1.MacroName"
objExcel.Run "YourMacroName"

' Uncomment this line if your macro makes changes that need saving
' objWorkbook.Save

' Clean up: close the workbook and quit Excel
objWorkbook.Close
objExcel.Quit

' Release the objects from memory
Set objWorkbook = Nothing
Set objExcel = Nothing

Pro tip: Double-click the VBS file to test it first—this will run the macro immediately, so you can make sure it works before setting up the schedule.

Now we’ll use Windows Task Scheduler to run this script automatically at your chosen time every day:

1. Open Task Scheduler (search for it in the Windows Start menu—it’s a built-in tool).
2. In the right-hand pane, click Create Basic Task.
3. Give your task a clear name (like "Daily Excel Macro Run") and a quick description, then click Next.
4. Choose Daily as the trigger, then set your desired start time and confirm it repeats every 1 day. Click Next.
5. For the action, select Start a program, then click Next.
6. In the "Program/script" field, browse to wscript.exe (it’s usually at C:\Windows\System32\wscript.exe—you can also just type wscript.exe directly).
7. In the "Add arguments (optional)" field, paste the full path to your VBS file, enclosed in quotes if there are spaces in the path. For example: "C:\Users\James\Desktop\RunDailyMacro.vbs".
8. Click Next, then check the box that says "Open the Properties dialog for this task when I click Finish" before clicking Finish.
9. In the Properties window:
   • Go to the Settings tab and select "Run whether user is logged on or not" (this lets the task run even if you’re not signed into your computer—you’ll need to enter your Windows password here).
   • Optional: Head to the Conditions tab if you want the task to wake your computer from sleep to run, or adjust other power-related settings.

• If the task fails, check the History tab in Task Scheduler—it’ll tell you exactly what went wrong (common issues: wrong file path, Excel file is password-protected, or permission errors).
• If your workbook has a password, add this line right after opening the workbook: objWorkbook.Password = "YourWorkbookPassword".
• Make sure Excel isn’t set to block macros—you might need to adjust your Trust Center settings to allow macros from the location of your workbook.

内容的提问来源于stack exchange，提问作者james