Search Word for text and send values next to text to Excel file

[fordma2831]

This is my first post and I am not certain that I have exhausted the search function on the board, but I was hoping someone could point me in the right direction. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I am using Windows XP and Office 2003. <o></o>
<o></o>
I am looking to automate a process where information is sent to someone in a text format and they in turn transfer that data to an excel file. It basically looks like this (but includes a lot more info):<o></o>
<o></o>
Service Request #: 123456<o></o>
Instrument Type: New Instrument<o></o>
Lot/Serial #: 123456<o></o>
SR Type: Product Complaint<o></o>
Service Coverage: Maintenance Agreement<o></o>
<o></o>
The info on the left (text preceding the colon) is always the same but the values following the colon can change. The excel file has all of the text before the colon and they just enter the information into the cells. I am looking to make it so that an Excel macro (or maybe a word/outlook macro) automatically scans the text document and sends this info to the exact same cells in excel every time. <o></o>
<o></o>
The text file is actually a message from an Oracle database and I am not going to be able to make any changes to the way the data comes in. <o></o>
<o></o>
My only real experience with VBA is from recording macros and looking at them in the editor. I did just pick up a book though...<o></o>
<o></o>
Does this seem feasible? <o></o>
<o></o>
Thanks for the help. <o></o>
<o></o>
Matt <o></o>

 

[Legacy 68668]

Ahh... missed one Trim

       If .exists(Trim(a(i, 1))) Then a(i, 2) = .item(Trim(a(i, 1))) : .remove Trim(a(i, 1))

 

[fordma2831]

Ahh... missed one Trim

       If .exists(Trim(a(i, 1))) Then a(i, 2) = .item(Trim(a(i, 1))) : .remove Trim(a(i, 1))

Adding this line seems to reduce the amount of cells that get populated.

Nevermind- I entered it incorrectly. It works perfectly now. Thanks Seiya!

 

[Legacy 68668]

Adding this line seems to reduce the amount of cells that get populated.

? I don't understand it...
It should never affect such way, but reduce the field that doesn't match in the message.

Nevermind- I entered it incorrectly. It works perfectly now. Thanks Seiya!

OK