Search results for query: *

Ok. Thanks I have washed it, but I take the first number in the first tab, then search for that number in all col 21. If I find it, I paste the number in col 22. Then I take the next number in Sheet one and do the same in sheet 2. There will be 1000's of records potentially. I intend to try Skip...

So sorry but that did not work me. Thank you

Hi Skip Interesting, I'm just curious that the numbers that made a match are not indicated by that cell. I need this to perform a sort of those that are found specifically. When there is a match, I must somehow select the entire row and move it to another sheet. Or do a sort on the column of...

For some reason I've lost this reply 2 times already. sorry If this is lacking. I'm not concerned about the values in the cells containing leading zeros. I can fix that if I need to. My problem is that I have to capture a value in Column1 and then search through all the records in column2 and...

Hi all I've tried this a multitude of ways and none work. My assignment is to take one text value in A1 and search D:D for that value. I've been somewhat successful, except I'm doing it from my macro editor because I don't know Excel VBA well and can't seem to fudge it this time. I have trouble...

Well I was asked to make the existing code loop. I see what you do and I know it has major bloat, but since it isn't technically wrong, I just want to do the loop. I realize she has waithosts where she doesn't need them and also she doesn't have any type of validate when moving screen to...

I think I'm going to write in Extra Basic since I know how to make it work from there. I really need to learn VBA though. The simplest things throw me. Thank you for help.

Also, I'm fully aware of the wait host issues. I'll put a sub to ensure the macro goes where it is supposed to.

Yes. I agree with re the wait times. I have code for that. I'm coming in after that was completed. Not really 16000 columns. I'm sure I'll reduce that. How can this work? 'Counter will represent the column Dim counter as Integer counter = 2 For counter 2 to 300 step 1...

Thank you so much! Sorry I thought it needed to be attached. It is clear to me it was originally created in the macro editor then put in Excel. I will copy for you here but let me know if it is not what you wanted. along with the For Next I added,Set curcell = Worksheets("Payment").Cells(15...

I keep typing this and then it disappears after a minute. So I better go fast. Original code works on one account. Requests it to loop through many accounts. The column is the variable counter. I cannot, with this code, copy and paste back and forth between Reflection and Excel. Thank you for...

Hi Skip - I was hoping you would show up. I did provide my code as an attachment and the knowledge base article where Reflection directly addresses this subject and provides different options such as wait for cursor, or keyboard enabled. Problem is as you will see in the attached code sample...

Hi all Reflections doesn't recognize Legacy Attachmate macro wait host times. It tends to hesitate as it works through a macro for upwards of 45 seconds. I've attached a macro dropping in suggested code from Reflections knowledge: https://support.microfocus.com/kb/doc.php?id=7021465 I get run...

Can you try putting it in a local folder and see if it will open in a simple path. Also I would not use the // as I believe it indicates something is behind the // yet not included in the path. Looking at your last snip, I would start the path with "F:\Public...."

Unfortunately I cannot use this code as is. When I paste it in to an Extra macro it won't compile. Would you mind creating it in the Extra environment? I'll provide some standard code for establishing objects below. This code shows standard macro declarations in Extra and then Excel plus has a...

You know how you established the objects with Extra? (Dim Sys As Object, Sess As Object, MyScreen As Object, MyArea As Object) You have to do the same for Notepad. I don't know the object hierarchy for Notepad tho.

Ok.... I used the suggested form loads in my main code block: Load UserForm1 UserForm1.Show It appears to work. Then I went to the form and wrote the code under the clicked event. Private Sub CommandButton1_Click() Dim entIdTp As String Dim entIdNum As String Dim entOcc As String...

Option Explicit Private Sub CommandButton1_Click() End Sub Private Sub CommandButton2_Click() End Sub Private Sub Label1_Click() End Sub Private Sub Label2_Click() End Sub Private Sub textBox1_Change() End Sub Private Sub TextBox2_Change() End Sub Private Sub TextBox3_Change() End...

Does someone have a simple bit of code that encompasses running a dialog box with only labels and textbox inputs in a macro? I'm not sure why I'm having such a problem, but sometimes the simplest things get lost in the trees. Here is the form. I don't know how to call it from the macro or how to...