I don't really know if there is a way to do this, so i figured this is the best place to start. I currently have an Excel spreadsheet that I was manually making. Column A contains entries like:

Log435.log
Log364.log
Log758.log

What I would do is manually make each one of those a hyperlink to C:\Logs\whatever log is referenced.

Now, I have that spreadsheet set up as a query from a SQL Server database. Everything imports fine and the spreadsheet is much better because now I just have to refresh the data.

I am wondering if there is some way through functions or VBA to have Column A entries be hyperlinks. All the logs listed will be in the C:\Logs folder and the whole file name will be the entry in column A.

Anyone know of a way to do this? Thanks for your help!

Scott