ERT Utilization.xlsm
http://ert.pbg.pvt/infosis/reportvie...HhJqtUxiw_RiTc

I have this formula in cell b1 that I've pulled from and outlook email. I have 9 other hyperlinks with different names following it up to b10. I need to be able to open this link (which opens a read only excel file called reportviewer.xls Each hyperlink opens the same file. I want to open each and extract the data onto a tab in my workbook but cant figure out how I click on the link through a macro since the file path changes week to week. The hyperlink is derived from the text in the email
HYPERLINK(LEFT(MID(A6,FIND("http:",A6),1000),LEN(MID(A6,FIND("http:",A6),1000))-2),LEFT(MID(A6,FIND("http:",A6),1000),LEN(MID(A6,FIND("http:",A6),1000))-2))

Any help would be greatly appreciated.