LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
Posts: 1
Default 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?

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
"paste special" a hyperlink to another worksheet... Guy who thought he knew Excel -) Excel Worksheet Functions 0 September 12th 06 09:45 PM
sort excel spreadsheet with hyperlink jannkatt Excel Discussion (Misc queries) 0 June 13th 06 01:39 PM
answer to odd results when comparing hyperlink addresses Patricia Shannon Links and Linking in Excel 0 March 9th 06 07:28 PM
Using the Hyperlink Function and finding filenames Jeni Q Excel Worksheet Functions 0 September 20th 05 02:37 PM
automate hyperlink GEORGIA Excel Discussion (Misc queries) 8 August 15th 05 10:18 PM

All times are GMT +1. The time now is 04:22 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"