Urgent Help needed - On Formating a page
 

Hi, I am in need of some urgent advise. Not sure if this is the right group.
Pls advise if this is not the right group.

I have a VB program that generates Excel Reports daily and weekly. There is
a code in the program which formats my report output in a certain format. I
had it run automatically via Task Scheduler in Windows daily. Here is the
problem that I am having:-
1. The task runs fine whenever I am logged in to my machine, i.e. I am able
to get my reports with the formating I've set.
2. The task FAILS to run, if I am logged off from my machine. After some
trouble shooting, I found that the codes that takes care of my output
formating failed to run when I am logged off. It seems that I need to log in
to windows in order for the codes to be able to format my report and run
without a hitch. If I log off from my machine, the script or task fail to run.

I am suspecting that in order for me to be able to format my report in
excel, I have to be logged in to my machine when the script runs. This cannot
be the case as I am currently trying to run it on another machine which I
should not be logged in all the time. Have anyone encounter this before?

I hope I've been cleared in my explanation. WOuld appreciate if anyone could
reply with their thoughts.

regards
noreadib.....

Urgent Help needed - On Formating a page
 

You could configure the scheduled task to run under your user account.

If you're formatting page layout, there are some things that require a
printer be installed.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"noreadib" wrote in message
...
Hi, I am in need of some urgent advise. Not sure if this is the right
group.
Pls advise if this is not the right group.

I have a VB program that generates Excel Reports daily and weekly. There
is
a code in the program which formats my report output in a certain format.
I
had it run automatically via Task Scheduler in Windows daily. Here is the
problem that I am having:-
1. The task runs fine whenever I am logged in to my machine, i.e. I am
able
to get my reports with the formating I've set.
2. The task FAILS to run, if I am logged off from my machine. After some
trouble shooting, I found that the codes that takes care of my output
formating failed to run when I am logged off. It seems that I need to log
in
to windows in order for the codes to be able to format my report and run
without a hitch. If I log off from my machine, the script or task fail to
run.

I am suspecting that in order for me to be able to format my report in
excel, I have to be logged in to my machine when the script runs. This
cannot
be the case as I am currently trying to run it on another machine which I
should not be logged in all the time. Have anyone encounter this before?

I hope I've been cleared in my explanation. WOuld appreciate if anyone
could
reply with their thoughts.

regards
noreadib.....