I need my VBA Macro to locate text throughout a document and move it. The information that needs moved can easily be detected by the font colors. For example:
"Celica Toyota": Toyota would always be a specific Green font and Celica would always be a specific blue. There can be more than one word in the range that needs swapped (ie: "Monte Carlo Chevrolet").
I have some really long drawn out code, but there's got to be something more efficiant.
I have a text box in which you enter last name first and first name last ex. (wojo casey) and I would like to change it so the output states Casey wojo
In Visual Basic 2008 Express edition: Create a new string replacing the order of the words, from last one to the first one and show it in a text box..Example: Input: This is an example Output:example an is Thisť..I know theres a function to reverse the letters (StrReverse), but the order of the words?
I've managed to become semi-literate in regex's, I'm stuck on this one though. I need to capture up to 5 words before and after a given word (not necessarily in the same sentence). So, for example, if the target word is AARDVARK in the following text:
AND A TRIP TO THE ZOO. THE AARDVARK WAS THE MOST INTERESTING CREATURE HE HAD EVER ...
I would like to capture {A, TRIP, TO, THE, ZOO} & {WAS, THE, MOST, INTERESTING CREATURE}. Obviously, if I could simply capture the whole string "A TRIP ... INTERESTING CREATURE", I can parse out the words.
Is there a simple way to insert a specific word between 2 or more words that of course have spaces?I'm doing if and next and if and next.I have 200 columns of programming for something that it may be simpler to make.So, p.e with the word "and", "Hello world" will be "Hello and world" or p.e. "Hello nice world" would be "Hello and nice and world".Words can also be like "Hello nice world"(doesn't show here,the spaces are "hello nice world" .I don't mind the spaces between to be only one but the words must be separated with the key word and space before and after.
complete coding newbie, but I'm trying to make a program that displays how many people are in a telephone queue by reading from a log file. and havign a timer update the number every 3rd second.
I'm writing a text adventure that takes place in the World of Snorf.Console.WriteLine("You are in the world of Snorf. The sky is pink. A gentle breeze blows across your naked skin.") When I debug this, the line gets cut through the word "your".How can I have the words automatically wrapped between the words?
It has been a while since I have used regular expressions and I'm hoping what I'm trying to do is possible. I have a program that sends automated response regarding a particular file and I'd like to grab the text between two words I know will never change. In this example those words are "regarding" and "sent"
Dim subject As String = "Information regarding John Doe sent." Dim name As String = Regex.IsMatch(subject, "")
So in this case I'd like to be able to get just "John Doe". Every regexp I'm coming up with includes the words "regarding" and "sent". How can I use those words as the boundaries but not include them in the match?
attached is my project on making multiple words from 1 word
This solves the word and has an option to save. Or it solves and saves all words in a list. I tried to do it with jokers using the jokers as every letter but it slows the program down drastically.
But it replaces all abc to google. But I need to change first abc to google and second abc to yahoo and so on.also tried this one
Quote:
Dim m14 As MatchCollection = Regex.Matches(TextBox1.Text, "abc", RegexOptions.Singleline + RegexOptions.IgnoreCase) For Each n1 As Match In m14 Dim value As String = n1.Groups(0).Value 'MsgBox(value)
I recently had some problems with the performance of the Word object model. In an add-in that I wrote for Word I need to parse through all the words of a document and replace some of them or ask the user for the ones that have multiple replacements. I know that it is faster to ask Word for all of the document text content at once and then process it and put it back all at once again, but this is not suitable for my add-in because I need to have access to the range objects that represent the words that have multiple replacements so that I can somehow mark them in the document and present the user with a tool tip from which he can select the replacement he wants.
So for the moment the single great speed improvement that came in my head was multithreading since most people already have dual core or better. The problem is that all the things you find on Google say that multithreading in Office is a very bad thing to do.
So is there any one who managed to do this in a manner that worked in most of its usage? By this I mean if it also worked on other PCs then the development one?
The text file words.txt contains a list of words. Write a program that displays the words in a list box sorted by the number of different vowels, they should be ordered first by their length(descending) and then alphabetically. The display should show both the word and the number of different vowels in the word.
So I have Private Sub btnDisplay_click handles(...) btnDisplay.click Dim Words() as string= io.file.readalllines("words.txt) I can use for each word in words to check each word but I don't know how to check how many vowels are in each word or how to order them.
I am trying to do a bubble sort using arrays and i am trying to sort a word in its alphabetical order... and my problem is that. i could not assign a value into my array from my textbox and get the length of the word from the text box... i do have this alogorithm'dim asd () as string'asd() = Text1.text'Len(asd()) but it seems that it doesn't work that way as what i am thinking.how to do it? it has been bothering me for days now and even if i do a lot of library sessions for this but still i could not find what i want to know.
I'm trying to use a stack object to reverse the order of words (not letters) in a sentence. I'm fairly sure that the split and push methods are working, but I can only get the first word (i.e. the first word in the original sentence), to be displayed.
I have the following code:
Private Sub btnReverse_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnReverse.Click Dim s As New Stack
I recently started wondering about how Microsoft would go about checking the text and checking its color, word order (spell check), etc. and I was trying to think of how they would do it if they were forced to write something, like Word or the text editor in Visual Studio, in Visual Basic.NET. Ways that I thought of could be using an array, setting a string to a word in that array, and check if that word is in the text. However, after I tried it, I realized I had to set the .SelectionStart property to zero, which got annoying if the document was long. Also, with arrays, though I could store the strings in a text file and read from that, I was limited to the number of items I could have, and I'm sure it would get frustrating if I added or subtracted a word (then having to back in the code and replace all of the instances of that array.)
Then I started thinking about streams. Though I have not tried them yet, I would imagine that if they had to be used, the problem of speed would come up again. But what if the stream only checked say 30 characters before and after the current selection start? Well, that would solve the speed problem, but it would bring up another. Every time the caret position changed, (if we were checking for color changing) we would be limited to those 60 characters. Say the word is "hello". What if "hello" began 31 characters behind the current SelectionStart? "h" would remain the same color, but "ello" would turn the default color (this is because we would have to reset the color everytime just in case the user changed a certain word.)
I'm trying to make a form that will read my wordlist. txt (one word or phrase per line) then using a timer, insert one word randomly selected from the list, and display it in textbox1 where it will remain until another timer changes the word. The word in the textbox will display for a random time 1min to 7 min, then the textbox displays another word randomly selected from the word list.
I write an HTML file with MS Word, and use it on my application. The problem is that I need to close Word or Visual Studio in order to save the file, or compile the code, because each one reserves the file permission rights. The html file is only written by word, and only read from VS. At compile time, the file is copied to execution directory. Is there a way to give both programs simultaneous permission rights?
i wanted to link options selected from Comb box A (general) to specific options in combo box B (specific). I want to pick a word in Combo box A that has specific words/phrases in Combo Box B show. But not all the words to show in the combo box B if they aren't associated with the Word picked in Combo Box A. Ex.When "Soda" is picked in A, only "Coke, Sprite, Fanta" should be visible in combo box b, not everything else.This is the code i used to make the boxes, but i don't know how to link them.
Private Sub MainForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load ' fills the combo boxes with values Me.xGeneralComboBox.Items.Add("Soda") Me.xGeneralComboBox.Items.Add("Juice")
I have 4 set of words store in array and wan randomly selects and scramble its letters in a label. i just know how to do the coding part of randomly display the words in the label but it no scramble i have no idea to do the scramble part, any expert can give the solution or example?
I am trying to split a long string based on an array of words. For Example:Words: trying, long, array Sentence: "I am trying to split a long string based on an array of words."Resulting string array:Multiple instances of the same word is likely, so having two instances of trying cause a split, or of array, will probably happen.
I've got 2 RTB one is for input of text and one is output.The output one needs to read the words from the input and display it alphabetically and with their line numbers.I have partly done it and it currently reads it but here is my problem When the words are outputted let say for example there are 2 words the same on the same line e.g the word 'you' appears twice on line one,at the moment its coming up like this
I have a combo box bound to a datasource. I need to change one combo box (of many) to order the items in descending order.I'm guessing I could order the collection in the dataset, but that will mean all my combo boxes will be reordered?
I have a databound Datagridview. The DGV is bound to a datatable of a strongly typed DataSet created using the wizard. Is there any way to re order the columns before displaying them eg: the Columns are displayed in the DGV in this other Col4, Col6, Col3, Col1,Col5, Col2
But I want to it to show as Col1, Col2, col3, Col4, Col5, Col6?
I realise that the display order followed the Column order in the database table and by extension, the datatable. I have re-arranged the columns in the Database but the Datatable still retains the old order.
This might not be so 'VB' as it is 'SQL using VB' I have an application with a built in MS Access DB. I have a table that has a column full of integers, I shoot the DB a SQL "order by 'column name' " string and it returns the table ordered by my column of integers.BUT it returns them like this, and I want them like this
0 6 1 5 2 4
[code]....
How do I get the OrderBY to do a descending list starting with the highest number?
I'm working on the exercise page 73 (VB 2010 in 24 hours). It's basically a form with 2 text boxes, 2 text labels and a command button. It's really simple and uses this loop to cycle through the items, and tell me the name of them in a Messagebox
other than GML (Yoyogames.com Game Maker Language), I am new to the coding world. The only "major" project I have completed using VB is a computer calculator that exactly mimics the capabilities of Windows 7's calculator. Yesterday, I began a Chatbot program for my girlfriend. Lol. I have used the instr() function to answer most of the questions or answers which are typed into the textbox1. I find this extremely troublesome because when using the instr() function you cannot say instr(textbox1.
Public Class Form1 Dim fos As String = "Foster: " Dim ash As String = "Ashley: "