Recent content by tchad

Anyone?

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.

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

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.

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

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?

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

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

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

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

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

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

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

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

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