Link to Lotus Notes Document through Excel

I'm wondering if anyone knows how to add a lotus notes document link directly into an excel sheet. I manage a notes database and have created an excel macro to pull some of the data into excel for reporting purposes. It would be awesome if I could use the macro to place some sort of link to the document itself.

It is easy to manually copy links by using the notes - edit - copy as link - document link, etc. Then in excel you can use the paste link as picture, etc, etc.

Is there any way a macro can create a link to a notes document automatically for every record?

[588 byte] By [Mark97] at [2007-12-23]