How do I get a program to run so that I can stay with a screen that doesn't move? I would like to get the data to update in excel without the screen flickering or moving and I want to see the data populate, not freeze the screen.
How do I get the program to run so that I can stay with a screen that doesn't move? I would like to get the data to update in excel without the screen flickering and I want to see the data populate, not freeze the screen.
I am trying to load a macro but my Extra reference keeps coming up missing and I am repeatedly told that there is a "Error in loading DLL".
I can always pull my back up and update it but would rather get the more current info.
How can I get around this to get to my code?
Better yet, how can I...
Ironically I have a different spot doing the Save As now. The one above is cleared but the other spot is at
Sess0.PrintDisplay
I cut it out, moved it to a different line, saved the macro, put it back where it is supposed to be and saved again and it seems to work now IF I am not in Excel. If...
Sound like a good idea to me. If the msgbox don't show it ain't working.
By the way, your idea for a counter worked great to solve some of my other problems. Thanks again.
Wow, I'm having amnesia and deja vu at the same time.
I think I've forgotten this before.
Very Funny!! :)
Actually the reason I am running loops is because a lot of the time I can't get the putstring to stick with just one line of code. I am taking to doing the same line of code three times...
Could anyone give me a hand trying to figure this out.
I am trying to collect array data (dynamic array) and am running an array to collect the numbers, a second array to collect the names assocaited with the numbers and then have to run a third array to collect the file label associated with...
I am having a printing problem where the documents get skipped. the code reads:
Sess0.Screen.WaitForString "** DOCUMENT PRINT SELECT **", 1, 24
Sess0.Screen.WaitForString "ID Description", 3, 47
Do While Sess0.Screen.GetString(2, 40, 4) <> PRTR
Sess0.Screen.putstring PRTR, 2, 40
Loop
Do...
Why does this trigger extra to try and do a Save As?
Test3 = Sess0.Screen.GetString(7, 32, 1)
Test4 = Sess0.Screen.GetString(8, 32, 1)
If Test3 <> Stuff Then GoTo Skippy
If Test3 Like Stuff Then
Call Missed
Sess0.Screen.SendKeys ("<Pf3>")
GoTo Y
End If
Oh ya, one more thing.
Calculus,
I tried the Do While Trim(Sess0.Screen.GetString(24,2,7))<> "DESIRED" way of doing things but the system would sit and do nothing for about 30 seconds at a time when ever the program went in and out of the main menu. Since this happens 4 or 5 times a file it...
So far I haven't been able to get host settle time to work from Excel. It won't recognize the library or the code depending on what going on.
While I understand that the way I go about changing screens is scary, I have only found two ways to get the macro to work for screen changes.
First - I...
I am running a macro from excel that goes into Extra. I tried to use
Do while Sess0.Screen.OIA.Xstatus <> 0
Doevents
Loop
But Extra runs the macro so fast it won't recognize a wait string.
I tried using Do While and Do Unitl loops but then the macro will sometimes skip a step and screw up...
Would this also work if the code runs to fast? My code goes from Excel to Extra and in Extra goes way to fast, it won't stop long enough to execute a wait string. Will the Do While work to slow down the execution?
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.