A
Alok
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
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