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!

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

Recent content by tchad

  1. tchad

    Reflection

    Anyone?
  2. tchad

    Reflection

    Hi, Just wondering if anyone here uses Reflection? We were updated today from Extra! to Reflections, and send keys, and how you reference the object are completely different. Hope someone can help me. Thanks, Chris.
  3. tchad

    Data from Excel to Extra and back

    I did, but the first lot of code below will run again if I abort the do. I need to keep looping but go to the next row. I did try it. With Worksheets("Multiple Store") For x = Rw To ActiveSheet.Rows.Count Keycode = .Cells(x, 1) Qty = .Cells(x, 2) Store = .Cells(x...
  4. tchad

    Data from Excel to Extra and back

    I don't want to exit the do though, as it will then repeat statements outside the do loop which I don't want repeated. I just need to go down to the next row within the loop, that's all.
  5. tchad

    Data from Excel to Extra and back

    If I exit do, I won't be able to copy the other rows of data in. I just want it to loop into the next row of data, but I can't put next x before loop...
  6. tchad

    Data from Excel to Extra and back

    Vzachin, Thanks for the info. I want it to go to the next row, but since the loop is placed first, all it does is loop forever. Is there a way to solve this?
  7. tchad

    Data from Excel to Extra and back

    Tried another code, basically I just want it to loop but it comes up with the error, "no for without next" Sub Newtest() Dim Sessions, System As Object, Sess0 As Object Set System = CreateObject("EXTRA.System") Set Sessions = System.Sessions Set Sess0 = System.ActiveSession g_HostSettleTime...
  8. tchad

    Data from Excel to Extra and back

    No, they are not always found at 7,7. What do I put instead? Yes, I do need the x = 1 statement. I got the below working today, but it stopped when I was getting the second lot of data on the first screen. Sub Newtest() Dim Sessions, System As Object, Sess0 As Object Set System =...
  9. tchad

    Data from Excel to Extra and back

    Hi vzachin, How does the below look? Is everything in the right order? Sub ExtractKeycode() Dim Sessions, System As Object, Sess0 As Object Set System = CreateObject("EXTRA.System") Set Sessions = System.Sessions Set Sess0 = System.ActiveSession With Worksheets("Input") Row =...
  10. tchad

    Data from Excel to Extra and back

    Hi vzachin, Thanks for the code. I need it to work so it works as per the following. Paste in PO number. Press Enter. Tabs down. ( I'll use the moveto command for this) Sendkeys "S" Enter Pulls data from the next screen, loops until it hits **** then moves to 6,2 and types C1 Enter. May...
  11. tchad

    Data from Excel to Extra and back

    Sub ExtractKeycode() Dim Sessions, System As Object, Sess0 As Object Set System = CreateObject("EXTRA.System") Set Sessions = System.Sessions Set Sess0 = System.ActiveSession With Worksheets("Input") Row = 2 Do Pull = .Cells(Row, "A").Value '**This will pull...
  12. tchad

    Data from Excel to Extra and back

    Hi, Thanks for that. I won't be pulling any data from Excel, just pulling it from Extra into Excel. So what loop can I use to terminate the sub once I've reached the point I want? Bear in mind, in my previous post it was ********
  13. tchad

    Data from Excel to Extra and back

    I have some code below, I can't get it to loop properly because apparently I don't have enough loop statements as opposed to Do statements. It basically starts at one screen where all the order numbers are, send S and Enter, pulls data from the next screen until it hits a certain point, then...
  14. tchad

    warning messge

    Like a message box warning? Use the code below. MsgBox ("Make sure macro is in c:\test.xls")
  15. tchad

    Data from Excel to Extra and back

    Hi, Example below. 5555 1001 29 5555 1002 50 Column A's number will never change, so I only need to pull that once into the first screen. Column B numbers need to match what's on screen, but if there is no qty (Column C) against a store number on the screen, a 0 needs to be put there. Not...
See more

Part and Inventory Search

Back
Top