Call Macro

J

jswalsh33

Can I call a Macro to run from a scheduled Task. If yes, How.

Thanks for your help.

Jim Walsh
 
M

Mike H

Hi,

You could do this. Create a task that opens a workbook at the required time
and in that workbook utilise the Open event to call your macro

Private Sub Workbook_Open()
Call MyMacro
End Sub

Sub MyMacro()
'Do things
End Sub

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Top