Automate Hyperlink insertion
 

I run a weekly MBSA scan that outputs it's findings into an CSV file. I
then use a macro to make the report easier to view and save into an XLS
file. I have a column in the XLS sheet called "Report Names". The
values entered into this column change weekly based on the output of
the MBSA scan. I want to have Excel based on the value in the "Report
Names" column
[ex. Computer1 (11-23-2006 5-30).mbsa] go to this network location,
find the correct file and hyperlink it to the value in the "Report
Names" column.
Is this possible? I'm sure I need multiple variables but this is a
little more in-depth then I've ever been with Excel...any ideas how I
can accomplish this?