Call Macro
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.
"jswalsh33" wrote:
Can I call a Macro to run from a scheduled Task. If yes, How.
Thanks for your help.
Jim Walsh
|