Creating Links to another application object

[Krazypoloc]

Hey guys first post. I'm a VB newbie so bare with me if this is a stupid question.

I am building reports from Remedy (ticketing application and database) into Excel Spreadsheets that contain pivot tables. I have a LOT of data and want to make it easeir for people viewing these by creating the ability to open Help Desk Case numbers (HDC's) that are referenced in my spreadsheet to the actual Remedy application. It should be a pretty basic function as if I create a file with the extension of ".artask" and input this code..

[Shortcut]
Name = HPD: HelpDesk
Type = 0
Server = remedyprd
Ticket = HD0000001006530

Then it will open HD0000001006530 in Remedy. I want an easy way to do this in excel as I have a whole column of HDC's.

So basically I need to know how to make Excel open what looks like a link in a cell to Remedy with a variable that is equal to the corresponding HDC# for that given cell.

Ideas?

[westconn1]

i believe excel hyperlinks would be suitable for what you want to do

[Krazypoloc]

And how exactly would I hyperlink to another application? Keep in mind this is hundreds of thousands of cell with HDC's in them so it needs to work for the whole spreadsheet.

[westconn1]

you can try recording a macro of creating one hyperlink from the appropriate cells, to generate some sample code, (make sure it works correctly), you can then make a loop to work down the page inserting all the hyperlinks