Thread: Call Macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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