Macro to copy from a text document into excel document

I would think you would need to provide a couple of sample text files and a sample Excel file where you've mocked up your needed results from those text files so we can see the BEFORE and AFTER. Then we can suggest methods of bridging the gap.

Please Login or Register  to view this content.

Oh, you want me to EXPLAIN everything? That'll cost ya! Hahaha! just joking!

This code worked on the sample file you u/led.

I'll have another look this evening and comment the code for you.

But for now, Dim Temp$ is the same as Dim Temp as String. It's shorthand left over from the early days. Each variable has it's own shortcut symbol.

Temp$ is just a temporary variable that is taking the text file in one line at a time. (Line Input)

Once I have Temp$, I check to see if our keyword (SOFTWARE: ) is anywhere in that line. (InStr) If it is, InStr will return the Starting Position of the match. So if iFound is anything other than 0, then we have a match. If it is 0, I loop to the next keyword until I check all the keywords, then read the next line and do it all over again.

Once a keyword is found, the Select case branches the code to the correct line to parse the info we need and post it to the spreadsheet.

Oops, sorry. I had the InStr function backward. And You! You have merged cells! A cardinal sin of Excel worksheets. I had to add a function to handle those devils.

It seems to be working now. Some of the info might not be formatted just right, so tell what needs to be fixed.

Please Login or Register  to view this content.