Hi SkipVought, thanks for replying
I'm aware of that from an 2015 post here in tek tips. But the issue still remains, even with the doevents waiting for the system to answer.
Excel keep's informing OLE issues.
Shure, there you go Dim System As Object: Set System = CreateObject("EXTRA.System")
Dim Sessions As Object: Set Sessions = System.Sessions
Dim Sess0 As Object: Set Sess0 = System.ActiveSession
Dim Screen As Object: Set Screen = Sess0.Screen
Dim OldSystemTimeout As Integer...
Hello everyone
Before the update for Office 2013, my macros in vba connectiong with Extra! Client 6.5 was working better than ever. After this update (or something else that i'm not aware), the same macros doesn't.
Eveything was checked:
- reference in VBA
- object creation and assingments...
Tks SkipVought...it worked really well and fast as possible without copy errors. Was wondering if it's possible to measure the system waiting time and send it to a var/string
did:
sess0.moveto 24,80
sess0.WaitHostQuiet(0)
do until sess0.waitforcursor(1,30)
do events
loop
Hey remy988, thank you for the informed thread. Seems to work fine.
If you use this method, do you change the position of the cursor during the screen transactions?
i.e.:
...
sess0.moveto 24,80
do until sess0.waitforcursor(1,30)
do events
loop
...
Good day,
I'm trying to copy data from the screen (with Attachmate Extra 6.5) from a Session as fast as possible to avoid Server capacity overload using the following:
Myscreen.SendKeys ("<Enter>")
Myscreen.WaitHostQuiet (0) 'used as time marker to xServerBusy
Myscreen.WaitForCursor 1, 30...
Here a better explanation:
Dim pass as string:pass = InputBox("Mainframe Pass")
.PutString (pass), 12, 60
.SendKeys ("<Enter>")
.WaitHostQuiet (0)
Keep in mind that the registered password would be "PassWord!02".
The event inputbox occurs into the excel vba code and the user insert...
Hello Gentleman, could use some help...
When I acquired a password (string) from an inputbox in excel vba, suddenly faced an unusual situation: for a password field in extra 6.5!, sendkeys and/or putstring turns the text into case Insensitive.
DO you faced anything like it?
thank you and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.