create hyperlink and run with macro

Hi,

I have an excel spreadsheet that gets generated from a dbms system. The first column of the spreadsheet lists an ID that is used to link to another web-based system.

What i would like to do is somehow create a hyperlink on this column so that when a user opens the spreadsheet they will be able to click on the ID and it will automatically open the front end web-system. The link should look someting like this:

http://pacs/itg/web/knta/crt/Request...QUEST_ID=40945

where 4095 is the value in the first column of the spreadsheet.

I was thinking that a macro would work, but not sure how to create it and have it run when opening the spreadsheet.

thanks
scott

Call the macro

Auto_open

to have it run when the workbook is opened.

You can see an example of how to create hyperlinks by macro on my download page.

Hi Martin,

i got to the download page but didn't see any examples on creating a hyperlink. I saw some other examples like changing colors on the graph but nothing about hyperlinks. Let me know i was looking at the wrong page or if you moved it somewhere else.

thanks
scott

It's on the final tab - the macro which lists files in the directory and produces hyperlinks to them.

The code is on the tab in the VBA editor