Dear Excel Gurus,

I need help.

I have written an Excel Application that processes data (extracts
information from other excel workbooks) and writes to a csv fie). This
processing can be done interactively using a button but the users want
to automate the process - and this process has to run just once a
week.

One choice is to use Application.OnTime. However, this will mean that
the computer that runs the process will have to run Excel continuously
for a job which hardly takes 5 minutes. Is there another approach?

Thanks.

Alok

Try Control Panel > Scheduled Tasks

"Alok" wrote:

> Dear Excel Gurus,
>
> I need help.
>
> I have written an Excel Application that processes data (extracts
> information from other excel workbooks) and writes to a csv fie). This
> processing can be done interactively using a button but the users want
> to automate the process - and this process has to run just once a
> week.
>
> One choice is to use Application.OnTime. However, this will mean that
> the computer that runs the process will have to run Excel continuously
> for a job which hardly takes 5 minutes. Is there another approach?
>
> Thanks.
>
> Alok
>
>

Hi Mike,
One can start a program e.g. and probably even invoke a specific
workbook using a parameter (though I have never tried it) but can one
get it to execute one of the many macros.?
Alok

On Sep 25, 7:46 pm, Mike <M...@discussions.microsoft.com> wrote:
> Try Control Panel > Scheduled Tasks
>
>
>
> "Alok" wrote:
> > Dear Excel Gurus,
>
> > I need help.
>
> > I have written an Excel Application that processes data (extracts
> > information from other excel workbooks) and writes to a csv fie). This
> > processing can be done interactively using a button but the users want
> > to automate the process - and this process has to run just once a
> > week.
>
> > One choice is to use Application.OnTime. However, this will mean that
> > the computer that runs the process will have to run Excel continuously
> > for a job which hardly takes 5 minutes. Is there another approach?
>
> > Thanks.
>
> > Alok- Hide quoted text -
>
> - Show quoted text -

Make your macro an Auto_Open and it will run when the workbook opens.

Tim

"Alok" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Mike,
> One can start a program e.g. and probably even invoke a specific
> workbook using a parameter (though I have never tried it) but can one
> get it to execute one of the many macros.?
> Alok
>
> On Sep 25, 7:46 pm, Mike <M...@discussions.microsoft.com> wrote:
>> Try Control Panel > Scheduled Tasks
>>
>>
>>
>> "Alok" wrote:
>> > Dear Excel Gurus,
>>
>> > I need help.
>>
>> > I have written an Excel Application that processes data (extracts
>> > information from other excel workbooks) and writes to a csv fie). This
>> > processing can be done interactively using a button but the users want
>> > to automate the process - and this process has to run just once a
>> > week.
>>
>> > One choice is to use Application.OnTime. However, this will mean that
>> > the computer that runs the process will have to run Excel continuously
>> > for a job which hardly takes 5 minutes. Is there another approach?
>>
>> > Thanks.
>>
>> > Alok- Hide quoted text -
>>
>> - Show quoted text -
>
>

Many thanks Tim.
Your suggestion will definately work.
Alok