Type: Posts; User: Mekinnik
Search took 0.01 seconds.
January 31st, 2013, 01:11 PM
I have never used UIAutomation. Can you give me some pointers or example of how to accomplish the task I posted?
January 29th, 2013, 01:16 PM
I can not figure out why my send messages will only work when debugging. When I launch from the .exe file it appears that they are not firing. The code is just suppose to click a button on en...
November 6th, 2009, 11:37 AM
I found the fix for my issue. I changed 'answer' from a var to a string. Here is the new code.
string answer = null;
Console.WriteLine("\nDo you need a new ID number (y = yes/n = no)?...
November 6th, 2009, 08:55 AM
I have created a simple console program promting the user to answer yes/no. I am trying to prevent the user from hitting the 'Enter key' to continue. I am sure this is a very simple fix, however...
From what I can tell your code is missing some key information. This is how to generate a random number.
variable = Int((upperbound - lowerbound + 1) * Rnd() + lowerbound)
Thanks for the suggestions, I will change the + to an &, good point. I did figure it out. Just four simple lines.
If a = "" Then
ElseIf x = a Then
x = Mid$(rgch, Int(Rnd()...
First off, let me start with dglienna's quote:
The rules are not faulty, just a bit extreme IMHO. But I did not create them, I only have to follow them. Also, I am noticing with a lot...
With this function I am attempting to accomplish three tasks, but keep having issues with it.
1) I want to find within the string 'retval', any of the three letter words from the array...
I was to quick on marking this resolved. Another issue has come up. How can I make the InStr function not case sensitive. I am looking to search within 'retval' which is a random string for any form...
Thank you for your help. I solved it with the following code:
Dim arrWords(1 To 1145)
Dim i As Integer
For i = 1 To 1145
arrWords(i) = Sheets(2).Range("A" & i + 1).Value
That does not help, still get the same error. Here is an overview, I am trying to search within 'retval' for any of the values listed in column A rows 1 to 1145. If one is found, the function will...
Godd point on the Else statement, I did not think of that. The issue I am having is with the following line.
WrkSht = Olist.Sheet(2).Range("A1:A1145")
When I step through the code, it...
I am trying to search within 'retval' for any of the values list in the column range A1:A1145. Can anyone help with this, I cannot put my finger on what it is I am doing wrong. Here is my function:
I am trying right this code right now only I keep getting a ByRef error when it calls the Sub(LookForFiles). Any thoughts?
Private Sub UserForm_Click()
Is there any way to make the following GetObject line of code find the file. I am looking to have the code search the computer for the .xls file, then set it to wkbObj. Another thought is to create...
Never mind I figured it out myself.
Const test2 As String = "!#$*+,;:<=>?@^_|~"
x = Mid$(test2, Int(Rnd() * Len(test2) + 1), 1)
Thank for your suggestion, it works great. In continuing with the modify string issue, the second function has to insert a special character. Here is my code for your review. Right now...
April 29th, 2009, 10:19 PM
Another question within my modify string function. If 'a' creates the position within the string 'RetVal' to be modified, how can I test to see if the position 'a' already has a numeral? The...
April 29th, 2009, 09:52 PM
Thank you for the help. It worked out perfectly. I was just missing the function returns like you suggested. Thanks a million.:thumb:
April 29th, 2009, 01:50 PM
I tried what you suggested, but it is not returning the modified string. Any ideas as to what I am doing wrong? Here is what I have now, the sub, the calling function, and the called...
April 29th, 2009, 11:25 AM
Thanks for the reply. The issue I have now is how to return the modified string back to the function that called it. Here is what I have currently, the function that calls, and the...
April 29th, 2009, 11:15 AM
Like dglienna said:
Your function has no idea what min and max represent, they have to equal a number. Another issue is in the following line:
vitri = Int((Max * Rnd) + Min)
To create a...
April 28th, 2009, 09:01 PM
How would I go about modifing a string with code? Lets say I have a string '12345' and I want to change the 3 to a six. How could I accomplish this task. I know how to grab the 3 itself and change it...
April 28th, 2009, 08:55 PM
Thanks for the help guys.
Click Here to Expand Forum to Full Width