Call Macro

[jswalsh33]

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

Thanks for your help.

Jim Walsh

 

[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.

 

[Mike H]

Hi,

Forgot to mention you can also use the ONTIME method to run a macro at a
given time.

Have a look here

http://www.ozgrid.com/Excel/run-macro-on-time.htm
--
Mike

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