Can anybody help me out with creating a hyperlink function in Excel?

Question

I want to open a file while its name is not given manually in the function, instead of that the file name must be the result of other function in the same excel.
This is the function to open file where the name is specified. =HYPERLINK("D:\countries\India.doc", “country details”)
Eg: In ‘D’ drive I have a folder named ‘countries’ contain many files with extension of .doc (India, USA, UK, UAE, Spain). I one more functions in the same excel file where I want to create a hyperlink function. This function’s result (result is not same always) is the file name I want to open by using this hyperlink. For that What changes I have to do in the function given above.

Answer 1

i'm not sure what version of excell you use. but if you go to insert tab and hit the hyperlink button that should do it (excell 2007)



https://answersrip.com/question/index?qid=20080712033935AAdoG0S

Answer 2

Right click on the cell, NOT highlight the work or numbers and right click and click hyperlink (Ctrl K)

Answer 3

coding for project-

http://codingforum.info/