Prev: Worksheet protection with exceptions
Next: Excell formula
From: jswalsh33 on 21 Feb 2010 05:28
Can I call a Macro to run from a scheduled Task. If yes, How.

Thanks for your help.

Jim Walsh
From: Mike H on 21 Feb 2010 05:35
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
From: Mike H on 21 Feb 2010 05:38
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.


"jswalsh33" wrote:

> Can I call a Macro to run from a scheduled Task. If yes, How.
>
> Thanks for your help.
>
> Jim Walsh
 | 
Pages: 1
Prev: Worksheet protection with exceptions
Next: Excell formula