If I fill in a number I want to open the word doc and pdf doc that is attached to that nr

[NikkiLi]

Dears,

I have on the first tab a screen where you can fill in the name of the .doc or .pdf file.
That works fine, but now I would like that when I fill in a number and click on test, it opens te .doc and .pdf file that is attached for that number.

If you take a look at the pdf file you will see a second and a third tab.
First column is the number they need to fill in and the second column is the name of the .doc or .pdf that needs to be opened with that specific number.

I have totally no idea on how to link it and open both files for that specific number.
But not every number has a .doc as well as a .pdf.

Is it clear what I mean?

I hope someone can help me further with this, already thanks in advance!

[chirag.patel22285]

Have a look at the attached file.

Hope this helps.....

[NikkiLi]

This is the same as the .doc and .pdf buttons except that this does both at once (So that is even better than seperate).
But what I'm trying to do is, that when you fill in a number of the first column, it searches on both tabs if the number is in the first column.
-> If the number that was given in D11 is in the first column of the second or third tab it needs to open the document and/or pdf of the second column. (the second column, the numbers are names of the documents)

Is this clearer? It is difficult to explain I think

[chirag.patel22285]

Hey,

So far I have done till here. Will continue on this tomorrow.

Hope this helps.

[NikkiLi]

Thanks a lot for your help!
With your document I could make it work.
I changed the cells, because they had a green triangle I checked them and converted them to numbers.
After that the whole thing worked!!

Thanks a lot!

[chirag.patel22285]

I am glad I could help!!!!

Enjoy excel.....