Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"paste special" a hyperlink to another worksheet... | Excel Worksheet Functions | |||
sort excel spreadsheet with hyperlink | Excel Discussion (Misc queries) | |||
answer to odd results when comparing hyperlink addresses | Links and Linking in Excel | |||
Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
automate hyperlink | Excel Discussion (Misc queries) |