C
Chuck Reed
I have an Access database that I launch daily using the windows task
manager in XP professional. The VBA code that I use in the Access
database needs to interact with outlook and excel. What I have
discovered is that my VBA code does not interact with outlook or excel
when it is launched using the Task Scheduler (When no one is logged on
to the workstation). If I were to launch the code when I'm signed on
to the workstation, ineraction with the other two office applicaitons
works fine. It's like task scheduler grants permission to run an
instance of MS Access but not the other two programs.
Does anyone know any work arounds to start instances of these other
applications under the task scheduler to ensure that the VBA code
running in access can interact with the other two applications?
manager in XP professional. The VBA code that I use in the Access
database needs to interact with outlook and excel. What I have
discovered is that my VBA code does not interact with outlook or excel
when it is launched using the Task Scheduler (When no one is logged on
to the workstation). If I were to launch the code when I'm signed on
to the workstation, ineraction with the other two office applicaitons
works fine. It's like task scheduler grants permission to run an
instance of MS Access but not the other two programs.
Does anyone know any work arounds to start instances of these other
applications under the task scheduler to ensure that the VBA code
running in access can interact with the other two applications?