QUESTION ABOUT EXCEL HYPERLINKS

[IncredibleVolk]

I currently run a DTS package where the results are pushed into Excel using an ActiveX script. The results are a summary (or count) of fields in a table. I'd like to create a hyperlink that will allow the user to click on the cell to get more detailed, drill-down information. I was wondering if it's possible to substitute the address field in this hyperlink for an sql query that will display the drill-down results when the user clicks on the cell. The value is already stored in the cell, I'd just like the user to get detailed account information about that value.

oSheet.Hyperlinks.Add oSheet.Cell(iRow,iColumn), "

http://XXX/XXX/",

, , ""