We currently run a macro in EXCEL to extract data from 3270 EXTRA! for SNA Server. We are using the waitforstring command. It works great on the computer the VBA was written on, but on everyone else's computer it hangs up for several minutes.
Dim Sess0 As Object
Set Sess0 = System.ActiveSession
checkscreen1 = Sess0.screen.waitforstring("** PRESS ENTER OR NEXT SCREEN")
Once the session finds the string (** PRESS ENTER OR NEXT SCREEN) it should continue the macro.
The file is accesed through a network and all users are using the same file, same version of EXCEL and same version of 3270 EXTRA. All computers have the same memory/hard drive capacity.
What would make it speed on ones user's computer and drag on the others?
