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
Microsoft ISV Community Center Forums3