Hyperlink.Follow question
 

I have a workbook that I download from a report server that has links to
other detail workbooks. When I do a hpyerlink.follow it opens the detail
workbook fine but it opens in windows explorer and is always named
WFServlet. I can copy the data out of it and insert a new tab in the
original workbook but after I do that I cannot get the WFServlet workbook to
close in code so I can't follow the next hyperlink to get the next detail
data because it says it can't open 2 workbooks with the same name.

Any ideas?