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 TouchToneTommy 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: *

  1. ej2rms13

    Conditional Formatting with Two Criteria

    For certain applications it is beneficial to see the difference between bill of materials. The two conditions (take A&B for example) give the part numbers their description. The two BOMs being compared should have roughly the same parts/descriptions (not necessarily in the same order) however...
  2. ej2rms13

    Conditional Formatting with Two Criteria

    I am getting the data from a Reflection application. Basic operation of macro: Clear screen > go to specific page > enter assembly part number to retrieve bill of materials > copy part numbers and associated data > paste in excel > continue until end of BOM is reached. The same goes for the...
  3. ej2rms13

    Conditional Formatting with Two Criteria

    Hi Skip, Looks like it worked pretty well! Thanks for your help! Just as a side question...I built a macro to retrieve this data. Is it possible to find all the duplicates and highlight them through VBA (add on to my macro)? Are there any benefits of doing this through VBA or is it just...
  4. ej2rms13

    Conditional Formatting with Two Criteria

    I am having some issues comparing two sets of two columns. I have two data sets (1 & 2) and they each have two columns (A&B and C&D). I am trying to find the duplicates between the the two data sets and highlight the row. So whatever is in A&B has to match C&D. Typing everything out in a...
  5. ej2rms13

    Do Until Loop Syntax

    Im guessing I cannot avoid the waitforstring in my particular application. The only other idea I have is to copy and paste the code within the loop a couple times so that it speeds up the execution. [dazed]
  6. ej2rms13

    Do Until Loop Syntax

    Skip, Maybe I am not understanding waitforcursor in this application. For my application, the cursor will reside in the same position for the majority of the execution of the code. Let me provide another code I wrote as example (this is basically a rough draft however it works). Sub Main()...
  7. ej2rms13

    Do Until Loop Syntax

    Hi Skip, I've been working on and off this code for a while. I tried replacing all the WaitForQuietHost with WaitForCursor and this did not help. I believe the pause that I am enduring between the end of one loop and the other starting is this line of code: Do Until...
  8. ej2rms13

    Do Until Loop Syntax

    Thank you for your reply Skip! After some adjusting I was able to get the code working how I want it however it seems to take about 5-10 seconds to loop back to the beginning. Any insight as to how I can speed this up? Thanks
  9. ej2rms13

    Do Until Loop Syntax

    Hi, I am having some issue with my code. I am going through attachmate since this is the application my coworkers and I use the most. This is the last piece of the puzzle (apart from exporting some of the results to excel) for this code and I am at a loss here. It will give me syntax if I put...
  10. ej2rms13

    Extra! Check Value?

    Hello, I am fairly new to programming. I've had a couple classes in college about C+ and C++ so I've been trying to adjust to Attachmate Extra Macros. Basically I need to write an IF statement based on whether or not a value at a coordinate is blank or not. I need to check if coordinates...

Part and Inventory Search

Back
Top