Call Macro

  • Thread starter Thread starter jswalsh33
  • Start date Start date
J

jswalsh33

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

Thanks for your help.

Jim Walsh
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run a Macro at a certain time 2
Run Macro If Cell have "x" value 0
Before Worksheet Close 5
does xcel have a built in scheduler ? 2
Set Command button location 1
Open Workbook at a certain time 2
Create Macro to pull data from a warehouse management system? 1
Access Dcount (multiple criteria) 3

Back
Top