rial there
> :http://www.iopus.com/guides/winscheduler.htm
> Regards.
> Daniel
>
>
>
>
>
> > -Original Message-
> > From: excel-macros@googlegroups.com [mailto:excel-
> > mac...@googlegroups.com] On Behalf Of TAlgo
> > Sent: vendredi 17 juillet 2
t; -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] On Behalf Of TAlgo
> Sent: vendredi 17 juillet 2009 21:33
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Re: Auto Run Macro - Copy data from multiple
> workbooks
Thanks ..I've never created Windows task manager..is there a link or
sample guide how to create task manager and .bat file?
On Jul 17, 2:43 pm, "Daniel" wrote:
> Hello.
> Use the OnTime command in your macro. This means that your workbook has to
> be open and your macro running at the activation
Hello.
Use the OnTime command in your macro. This means that your workbook has to
be open and your macro running at the activation time. However, if you use
Excel 2007, you could place the master workbook in a trusted folder (that is
to say that an auto open macro can run at open without security
I would suggest recording a macro that does all of the things
you want it to do.
Call the macro auto_Open.
At the end of the macro, add:
Activeworkbook.close SaveChanges:=true
save the workbook.
Next, create a windows Scheduled task that will open this workbook at 5:00pm
daily
(or weekday)
test
