automation

[tjm77]

I am trying to automate a process that runs through the windows at command. It opens up access97 program that in returns trys to open another application that connects to our mainframe and extracts data. When I click and run it, it works. But when the at command calls it I get the following error : The specified module cannot be found

I don't understand this since it works fine through a user. the code is as followed:


stAppName = GetSetting("CSC", "Defaults", "ProgramFilePath", "&quot
stSessionName = GetSetting("CSC", "Defaults", "SessionFilePath", "&quot

Call Shell(stAppName & " " & stSessionName, 1)

startTime = Time
Do While DateAdd("s", 8, startTime) > Time
DoEvents
Loop

Dim myscreen As Object
Dim Sess As Object
Dim Sys As Object
'(fails here)
Set Sys = CreateObject("EXTRA.System&quot
Set Sess = Sys.ActiveSession
Set myscreen = Sess.Screen