PDA

View Full Version : Windows task scheduler and Excel



akn112
03-17-2008, 08:13 AM
I currently have an excel file that sets of the dos prompt and does a bunch of sendkey commands then closes. it works fine when i run it from the code. But when i try to autostart it from windows task scheduler, the sendkey commands don't work correctly anymore.

One possible reason i can think is that both excel and the ftp are not visible during the task scheduler session, but are visible when i manually run the code, is there a way to force the visibilty from the task scheduler?

can anyone think of any other reasons why it might fail? thanks!

Bob Phillips
03-17-2008, 08:32 AM
Not really, but have you tried it as a pure VBScript, don't bother with Excel.

akn112
03-17-2008, 08:37 AM
vbscript? is it different from the vba within excel?

Bob Phillips
03-17-2008, 09:01 AM
Very similar, it isn't typed though, so all variables are variants.