Urgent Help needed - On Formating a page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.....
 
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.
 
Back
Top