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...
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...
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...
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...
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]
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()...
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...
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
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...
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...
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.