Excel VBA macro crash
 

I've run into an annoying issue with an excel (2003) vba macro I've
created. When I run the macro and watch it run it performs great.
When I set it to run as a scheduled task and watch it run it is fine.
When it runs unattended, with the workstation locked it dies. Is there
any way to fix this?

thanks,
Patrick

Excel VBA macro crash
 

What does it do? Are you using anything which might be affected by
the workstation being locked (no idea what sort of things might, but
maybe sendkeys perhaps?)

Tim.


"Patrick" wrote in message
ups.com...
I've run into an annoying issue with an excel (2003) vba macro I've
created. When I run the macro and watch it run it performs great.
When I set it to run as a scheduled task and watch it run it is
fine.
When it runs unattended, with the workstation locked it dies. Is
there
any way to fix this?

thanks,
Patrick

Excel VBA macro crash
 

Yes, I am using send key in part of the macro. Need to triger and
login to a different program to iniatiate a download. So I take it
send key does not work on a locked workstation?

Excel VBA macro crash
 

"Patrick" < wrote in message
ups.com...
Yes, I am using send key in part of the macro. Need to triger and
login to a different program to iniatiate a download. So I take it
send key does not work on a locked workstation?


I have no idea, but it seemed to me like a reasonable thing to test....

"different progam" is what? Browser-based application? If so, are the
login fields on the page or in a dialog box?

If on the page, you should be able to automate IE directly to populate the
values without using sendkeys.

Tim.

--
Tim Williams
Palo Alto, CA

Excel VBA macro crash
 

The other program I'm launching is a fat client for our trouble ticket
system (Remedy).