How to create excel & word documents from a document (in a Domino database), then link them (word & excel docs) to the parent document?

HCL Domino Domino Forum
1

Hi great minds of the Notes/Domino 6 Forum!I have been tasked by my boss to create a database for our Software Release Notes, which are currently done manually. Our release notes usually have attachments created either in Excel or Word.

How do I go about allowing users to create an excel/word document from a Domino document, to edit the same when the need arises, and ensure that these MS documents are linked to the right Domino documents?

Can anyone point me in the right direction?

Thanks! ü

2

Subject: How to create excel & word documents from a document (in a Domino database), then link them (word & excel docs) to the parent document?

  1. You can check the Domino.Doc product family.2. Create an agent (java/lotus) and trigger by button to create word/excel document from within notes/web document.
3

Subject: How to create excel & word documents from a document (in a Domino database), then link them (word & excel docs) to the parent document?

How about making your “Software Release Notes” database a workflow application.

It could have a Form with an RTF on it. The RTF is populated by the user clicking on a Button on the Form (Document) which would let them navigate to a directory path and pick up Excel or Word files.

This can be done in Formula, but a neater solution would use LotusScript with a predetermined navigation path. That way, you can point the user directly at a Network drive or a specific directory on their Hard Drive.

I have done this before, it is not to difficult.

Regards

Rolf Pfotenhauer

4

Subject: RE: How to create excel & word documents from a document (in a Domino database), then link them (word & excel docs) to the parent document?

Hi there, Rolf!

Actually, I based my database on the Document Library template (it uses a workflow application, am I right?).

By RTF, you mean Rich Text File? Is there somewhere I could research on using LotusScript to specify a predetermined navigation path? I need these word/excel documents to be available to anybody with access to the database, so should these documents also be stored on the Domino database? Is that even possible? Would OLE work?

I hope I’m not annoying you with my countless questions, but I’m quite new to Domino Designer and there are still a lot of things I don’t understand.

Thank you so much for your time, and of course, your invaluable help.

Regards.