Dynamically specifying source location for Hyperlink in excel

TO FIND LOCATION OF EXCEL FILE :

=MID(CELL("filename"),1,FIND("[",CELL("filename"))-1)

CONCATENATING FILE LOCATION AND FILE NAME:

=HYPERLINK(P10&"index.html")