Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Pimafix
  • Order by date
  1. Pimafix

    Flickering Screen

    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.
  2. Pimafix

    Flickering 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.
  3. Pimafix

    Error in loading DLL

    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...
  4. Pimafix

    Extra trying to Save As

    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...
  5. Pimafix

    Second document in print is getting skipped

    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.
  6. Pimafix

    Second document in print is getting skipped

    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...
  7. Pimafix

    Multipule arrays not functioning

    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...
  8. Pimafix

    Second document in print is getting skipped

    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...
  9. Pimafix

    Extra trying to Save As

    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
  10. Pimafix

    How do I pace a macro?

    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...
  11. Pimafix

    How do I pace a macro?

    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...
  12. Pimafix

    How do I pace a macro?

    Thanks, I will give it a shot.
  13. Pimafix

    How do I pace a macro?

    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...
  14. Pimafix

    Macro Speed

    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?

Part and Inventory Search

Back
Top