Hi,
My problem here is that i have an image map located on a web page(.MHT file) with dot location markers(probably 150) with different hyperlinks over each one. They link to a workbook with X number of worksheets in it. My objective is to have dot AA link to Workbook A Sheet A and dot AB link to Workbook A Sheet B. i have been able to get a formula for this to work from a "directory" workbook of with all the dots names. The hyperlinks now can currently open the workbook but do not get directed to the correct worksheet.

I've tried C://Users/Excel/Area/Column/Dot-Name.xlsx#'worksheet1'!a1 (with and without single quotes)(opens workbook)
[C://Users/Excel/Area/Column/Dot-Name.xlsx]#'worksheet1'!a1 (displays error message)
I've tried replacing the brackets with the HTML code for brackets since the hyperlink is contained in html code.
I've tried naming a range of cells in a specific worksheet and have that directly after the #

Do i need to create a macro for this? Using Excel 2010

Thank you for any advice.

T-Mo