Importing from a text file without opening

check attachment, save both files, open Excel file, press "Start", select saved .txt file.
The data has been changed for testing purpose. That's all I understood from your explanation. If any changes are required. please shout.

wow thank you for all the replies and help. I just got back from a work-filled weekend =( so ill take a look and post as soon as I can. Thank you all!

Wow that is exactly what I wanted... but what was changed in the text file?? No way to make that work with the file I gave??? The end result from those files is exactly what I need though.

To clarify, where it says P###### for a sample, the corresponding result would be the result after Factor II, F###### would be for Factor V, and the M###### for MTHFR (there are 2 results for these numbers).

Ok no problem, sorry I was not clear earlier. Yes the 6 digits after X are what Im after (of course If Im looking for test X). So my plan was to use the code on 3 different sheets... one looking for P######, one for F######, and one for M######. In this dummy sheet, the X###### was P###### when I submitted (I think) so it would be looking for the result after "Factor II 20210G>A G/G; Mutation Absent"

If you look at the file imported into excel as a chart, itll line up like
Factor II 20210G>A G/G; Mutation Absent

And that would be the result for a P######.

Out of the file, for the sheet I use to look for P######, I just want to pull from the text every 6 digit number after P, and the corresponding result.

If it makes things easier I dont need the G/G, just the part that says Mutation Absent.

So in the end I want

892333 Mutation Absent
next sample etc...

see attachment, it searches for M, F, P tests in one go

Hi guys, again im sorry for the late reply Ive just been swamped. I worked with the attachment, but i actually still have the problem of not being able to see just 1 of those results vs all three. Sorry I wasnt clear on that =( the point of not opening the text for me is so I dont actually see all the results, only what is needed. The code from snb is great for grabbing some of the numbers, but no results =(. Im going to try to explain what I need better.

So I want a 5 sheet workbook. I already have written the first 2 pages, they are all just basically worksheets and have nothing to do with the samples, just instructions.

The last 3 sheets are labeled Test P, Test F, Test M. Id like to make a button in each with a preformatted page, to take all corresponding test numbers and results and list them in 2 columns.

So in sheet "Test P" id like a button, when pressed, prompts you to choose a text file, and then it imports all the P numbers and next to them the corresponding result. Again, the dummy file has 1 line (1 sample, multiple tests) but it can have many at once. They will be all set up the same way as the file looks except for the headers, so the results should be in the same place each time for each test ( a certain number of spaces after the label ex. Factor II ..........text in between....... Result)

Hope this is a better description. Again thank you all for contributing and helping... this has been a real problem for me!

I just realized something that might help. If you scroll all the way to the right on the dummy file, each sample has a unique "<Header AccessionNumber="34-P892333-F352356" that is easier to use I would think for the number extraction. I modified the dummy file so it now has more samples on it and looks more like a file I would actually get.

To reiterate:

Test P = Factor II 20210G>A G/G; Mutation Absent
Test F = Factor V 1691G>A G/G; Mutation Absent
Test M = MTHFR 677C>T C/C; Mutation Absent 0.99751 MTHFR 1298A>C A/C; Heterozygous

And I just need the "G/G; Mutation Absent" part for each test as a result. The Test M has 2 results. Id like those to list in 2 columns.

So For example, the Test P Sheet will end up looking like

Accession number || Result
892333 || G/G; Mutation Absent
823000 || G/G; Mutation Absent
777829 || G/G; Mutation Absent


So i dont want 1 button to do it all (unless it easier to program), I just need 1 set of code to handle test P, another for test F, and 1 for test M.

here is the dummy file.

impossible?? =(

Wow thats amazing!! The only thing thats missing is the fact that it only picks up F-tests or M-tests if it is first in the name. In this case for the dummy, I need it to pick up all the F's, ex. like in 99-P777829-F111333-M662222, I need it to grab F111333. But thats really amazing thanks for all your help watersev!

check attachment, I've made some corrections regarding your last post

By George I think we got it!! THANK YOU SO MUCH you have no idea how much this helps.... It saves me hours of sorting and legal paperwork haha. Thank you for staying with me on this it was a lot to ask and you really came through. Amazing job. Could not be more perfect.

actually it could ... I know that ...if you are ok with the result and there are no outstanding issues here, please mark this thread as solved (for How To questions please refer to Forum rules)

oh crap i just realized that the M test has 2 results... looking at the code you got the 677C>T one, but there is also a 1298A>C one thats actually right after that. I am obviously not proficient in code like anyone on this forum and I apologize for my lack of skills. Im trying to figure out the your code here and where you tell it to place the text in the cells. I also want to move everything down and have it start "pasting" at row 6 cause I have headers in the page to make it look nice. So test P and F are perfect (pending I figure out how to move the text down) and test M just needs the other result. Im trying to look at your code to learn how, but I keep messing things up =(.

it was my fault I just did not notice second result for M-test, check attachment, it should correct that to be as you'd like. In order to move result table for example: 5 rows down (columns are the same):

Please Login or Register  to view this content.

- the line responsible for output - as it now
5 rows down:

Please Login or Register  to view this content.

- 5 rows down - left upper cell - [a5]
I have moved result down to [a5] cell. Please test.

Im getting syntax error at

Please Login or Register  to view this content.

and it happens after I click the button for M test.

oh i think its just the space between sub and matches... i will try to fix

Ok i got it to work and it looks really great! I was able to move the output further down without a problem, except for some reason it deletes values (my headers) in row 1-5 (for Ptest and Ftest) and rows 1-4 for M test. But the results work perfectly!!

haha nevermind I got it... all I did was delete the

Please Login or Register  to view this content.

and now the file works so beautifully.

pending any other things I forget.. .this has been quite an experience! I greatly appreciate all your help watersev and will do my best to keep up on my excel-ing. Thank you!!