Scheduled tasks - create error reports



georgesmailuk@gmail.com
07-10-2005, 12:52 AM
I am using a scheduled task to open an excel spreadsheet. but when i
try to stop the task or if the task is set to stop after 10 mins an
error report gets created.

Can anyone advise as to what is wrong?

Pegasus \(MVP\)
07-10-2005, 12:52 AM
<georgesmailuk@gmail.com> wrote in message
news:1117536736.417108.106780@z14g2000cwz.googlegroups.com...
> I am using a scheduled task to open an excel spreadsheet. but when i
> try to stop the task or if the task is set to stop after 10 mins an
> error report gets created.
>
> Can anyone advise as to what is wrong?
>

Please supply some additional information:
- What exactly is the command line in your scheduled task?
- What account do you run the task under?
- What exactly is the message in the error report?
- How exactly do you stop the task?
- What happens if you do not try to stop the task?

georgesmailuk@gmail.com
07-10-2005, 12:52 AM
Command line?

i have run C:\test.xls
schedule: Daily at 13:10
every day
settings: stop the task if it runs for 10 mins

I am running under my own account - not administrator - but have used
the following from Kelly's corner

Scheduled Tasks - Applying/Running tasks without a password

For Pro: Go to Start/Administrative Tools/'Local Security
Policy/Security Settings\Local Policies\Security Options
Accounts: Limit local account use of blank passwords to console logon
only. This is enabled by default, disable it.

I am using a networked computer, running XP Pro

After stopping the task either manually or letting it run for the
specified 10 mins i get this error

Microsoft Excel has encountered a problem and needs to close. We are
sorry for the inconvenience.
Send error report - Don't send

When manually stopping the task, i right click on the tak and "end
task".

Pegasus \(MVP\)
07-10-2005, 12:52 AM
Excel is not meant to be run as a background task - it is designed
as an interactive program. Instead of killing it via the Task Scheduler,
close it in the usual manner (File / Exit). If you wish to automate
the process then you could write an Excel macro to do it. An
Excel or MS Office newsgroup could assist you there.


<georgesmailuk@gmail.com> wrote in message
news:1117538780.761696.82930@g43g2000cwa.googlegroups.com...
> Command line?
>
> i have run C:\test.xls
> schedule: Daily at 13:10
> every day
> settings: stop the task if it runs for 10 mins
>
> I am running under my own account - not administrator - but have used
> the following from Kelly's corner
>
> Scheduled Tasks - Applying/Running tasks without a password
>
> For Pro: Go to Start/Administrative Tools/'Local Security
> Policy/Security Settings\Local Policies\Security Options
> Accounts: Limit local account use of blank passwords to console logon
> only. This is enabled by default, disable it.
>
> I am using a networked computer, running XP Pro
>
> After stopping the task either manually or letting it run for the
> specified 10 mins i get this error
>
> Microsoft Excel has encountered a problem and needs to close. We are
> sorry for the inconvenience.
> Send error report - Don't send
>
> When manually stopping the task, i right click on the tak and "end
> task".
>

georgesmailuk@gmail.com
07-10-2005, 12:52 AM
Quite right - application.quit did the trick.

I had a query with the excel lot about scheduled tasks - no reply, but
you were right on the money.

many thanks
George

Pegasus (MVP) wrote:
> Excel is not meant to be run as a background task - it is designed
> as an interactive program. Instead of killing it via the Task Scheduler,
> close it in the usual manner (File / Exit). If you wish to automate
> the process then you could write an Excel macro to do it. An
> Excel or MS Office newsgroup could assist you there.
>
>
> <georgesmailuk@gmail.com> wrote in message
> news:1117538780.761696.82930@g43g2000cwa.googlegroups.com...
> > Command line?
> >
> > i have run C:\test.xls
> > schedule: Daily at 13:10
> > every day
> > settings: stop the task if it runs for 10 mins
> >
> > I am running under my own account - not administrator - but have used
> > the following from Kelly's corner
> >
> > Scheduled Tasks - Applying/Running tasks without a password
> >
> > For Pro: Go to Start/Administrative Tools/'Local Security
> > Policy/Security Settings\Local Policies\Security Options
> > Accounts: Limit local account use of blank passwords to console logon
> > only. This is enabled by default, disable it.
> >
> > I am using a networked computer, running XP Pro
> >
> > After stopping the task either manually or letting it run for the
> > specified 10 mins i get this error
> >
> > Microsoft Excel has encountered a problem and needs to close. We are
> > sorry for the inconvenience.
> > Send error report - Don't send
> >
> > When manually stopping the task, i right click on the tak and "end
> > task".
> >


Scheduled tasks - create error reports