Not sure if this is the right place for this post, but, .... here the my issue

[Everett Crockett]

Hello All!

I have a problem that I have been tasked to solve.

We have an application server (Windows 2000 Server), which
houses a "general output folder" for several nightly
reports and spreadsheets. The reports are generated via
crystal reports and the spreadsheets are generated through
a 3rd party app, which "exports to Excel"
via the previously mentioned crystal reports.

After creation, the spreadsheets need to be "resized" to
80 percent zoom. I have a routine that I would like
incorporate into a "Windows Service Application" which can
take care of the resizing. The problem is that I am not
sure how to detect the "trigger" for the execution of
the "service app".

I need the "service" to be "active" even if nobody is
logged on to the box. If the box is rebooted, I need
the "service" to be up and running. I need the "service"
to wake up and execute every time that a new spreadsheet
is deposited into this "general output folder".

Can anyone help me to figure out how to do this?

Thank you in advance for any and all suggestions.

Everett

 

[Dave Patrick]

If the workbooks are created at a fixed time then you can use Task Scheduler
to run your routine shortly thereafter.

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect


:
| Hello All!
|
| I have a problem that I have been tasked to solve.
|
| We have an application server (Windows 2000 Server), which
| houses a "general output folder" for several nightly
| reports and spreadsheets. The reports are generated via
| crystal reports and the spreadsheets are generated through
| a 3rd party app, which "exports to Excel"
| via the previously mentioned crystal reports.
|
| After creation, the spreadsheets need to be "resized" to
| 80 percent zoom. I have a routine that I would like
| incorporate into a "Windows Service Application" which can
| take care of the resizing. The problem is that I am not
| sure how to detect the "trigger" for the execution of
| the "service app".
|
| I need the "service" to be "active" even if nobody is
| logged on to the box. If the box is rebooted, I need
| the "service" to be up and running. I need the "service"
| to wake up and execute every time that a new spreadsheet
| is deposited into this "general output folder".
|
| Can anyone help me to figure out how to do this?
|
| Thank you in advance for any and all suggestions.
|
| Everett
|