I have tried Task Scheduler, but I can’t stop getting the error ActiveX can’t create component on line 3:
Dim WordApp
Dim Doc
Set WordApp = CreateObject("Word.Application")
Set Doc = WordApp.Documents.Open ("File_Path")
Doc.Save
Doc.Close
Set WordApp = Nothing
MsgBox ("Your Automated Task successfully ran")
I ran RegAsm.exe but no luck. Wondering if there is any other way to automate simply opening and closing a Word doc every day. I have a macro of interest that runs upon opening the doc, so the goal is just to get that to run daily.
New contributor
Christian Nelson is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.