Search results for query: *

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

I've got the below code to work. However, if I wanted to add more putstrings and getstrings, do I just add Example = (x,3) and so forth? Sub Main() Dim Sessions As Object Dim System As Object Set System = CreateObject("EXTRA.System") Set Sessions = System.Sessions Dim...

OK. Sorry, there should be 1 value, as it's only one cell going to Extra at a time. The cell goes into Extra, presses enter, and the result comes up just below where I put the cell of data in. The correct coords are at work, so that's no problem to add in once we have corrected the code. So...

Thanks for the reply. As I said, I'm only beginning with the copying of data to Extra, so please try to bear with me. I'm not sure where you are confused with what I've said. The GetString will always be from one place, so column and length are defined by myself when I check the coords in...

Hi, I do my coding in Excel VBA at work, I have only done extracting so far which I find easy enough, it's just the sending of data from Extra, then extracting then looping again which gets me. I have compiled the below code from what I have read tonight on the forums. I'll add the correct...

I won't have any code until I get back to work. I'm fine on extracting the data, it's just the part where I have to pull a cell from the Excel sheet, put it into Extra, and then loop the process again until no cells are left, which is what I need help with.