Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically run an Excel macro
I have an Excel macro theat I would like to automatically run using Windows
XP Scheduled Tasks. Is this possible...if I could invoke the macro via a BAT or CMD file that would be great. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically run an Excel macro
Put your code in a subroutine named Auto_Open, then use the task scheduler to
open your Excel file. Be sure your macro security is such that your macro can run without any prompts. "sxhwabbiemike" wrote: I have an Excel macro theat I would like to automatically run using Windows XP Scheduled Tasks. Is this possible...if I could invoke the macro via a BAT or CMD file that would be great. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically run an Excel macro
I did that, however whenever I try t view the file that was created by the
macro it reruns the macro. I woould like to save the file to a common site (iKnow) for viewing by others without it being recreated each time someone wants to view it. "bpeltzer" wrote: Put your code in a subroutine named Auto_Open, then use the task scheduler to open your Excel file. Be sure your macro security is such that your macro can run without any prompts. "sxhwabbiemike" wrote: I have an Excel macro theat I would like to automatically run using Windows XP Scheduled Tasks. Is this possible...if I could invoke the macro via a BAT or CMD file that would be great. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically run an Excel macro
There are several ways you could allow the macro to start automatically (via
the Auto_Open) and conditionally exit before it runs... For your purposes, it sounds like you might just check the path (activeworkbook.path) and exit if it's not your local copy. Also, FYI, if the file is found via File Open, then shift-click will open the file without executing the macro (vs clicking on Open which will open and execute). "sxhwabbiemike" wrote: I did that, however whenever I try t view the file that was created by the macro it reruns the macro. I woould like to save the file to a common site (iKnow) for viewing by others without it being recreated each time someone wants to view it. "bpeltzer" wrote: Put your code in a subroutine named Auto_Open, then use the task scheduler to open your Excel file. Be sure your macro security is such that your macro can run without any prompts. "sxhwabbiemike" wrote: I have an Excel macro theat I would like to automatically run using Windows XP Scheduled Tasks. Is this possible...if I could invoke the macro via a BAT or CMD file that would be great. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a macro to automatically open excel | Excel Discussion (Misc queries) | |||
cannot get my excel personal macro workbook to load automatically | Excel Discussion (Misc queries) | |||
excel macro to automatically change default printer | Excel Discussion (Misc queries) | |||
How do you run an excel macro automatically overnight? | Excel Discussion (Misc queries) | |||
Running a Macro automatically from Excel | Excel Worksheet Functions |