Word, Excel, Project, VISIO docs attached to Notes docs

HCL Domino Domino Forum
1

I have built a Project Mgmt. DB that has a Main Project form and several response docs including an estimation, requirements, scope, data model, etc. These documents will be rendered in Word, Excel, VISIO, Project, etc and will be kept in a specific folder. On the Notes document will be general info about the doc and a link to that doc in the particular software. My problem:

I would like to be able to click on the link to open the document in it’s native program, edit the document and then save it. Currently, when I do this it updates a temporary copy of the doc. Hence, any changes I make are NOT saved to the linked document. I have tried @Command([Execute]) but it opens to the same folder every time. The example in Notes Help doesn’t account for folders with spaces in the name. For example, my path is quite long:

F:\ATG Group\IS Projects\Data Mapping<projectname>\filename.xxx.

Thanks in advance.

2

Subject: Word, Excel, Project, VISIO docs attached to Notes docs

How are you creating the links? I know that if you Edit-Copy in the native app and then Edit-Paste special in a Notes document, you have to leave the native app open in order for the link to be OLE. If you close the app, you are only pasting a copy and future edits get saved in a temp version.

3

Subject: RE: Word, Excel, Project, VISIO docs attached to Notes docs

Hi,

I am actually working on kind of similar objectif. I need to create a button that is open to create any embed object kind of word, excel… and place the edited document in a ric text after edition. I tried different manner and get different results… the doc is not always really saved to my OLE… I saw also that editing the rtf or not before you click on my button make a big difference in the way the embed object is linked… all in all, I am lost and far from having the same effect as the real lotus button “Attachement”… How they did manage this ?? I am working in Lotusscript.

here is the code I am testing (object and hdl must be global values):

Set word_app = CreateObject("Word.Application")

If word_app Is Nothing Then

	word_app.quit

End If

'Create a new document

word_app.Documents.Add

'Retrieve handle to current document

Set activedoc = word_app.ActiveDocument

'Set the current dir where u want

'to save the document.

path = "c:\lotus\notes\data\domino"

Chdir path 



word_app.ActiveDocument.Saveas(Curdir()+"\"+"temp"+".doc")

word_app.quit

’ word_app.visible = True

'word_app.quit 



'le document doit déjà avoir été sauver une fois pour que le champ existe

Set body = doc.GetFirstItem("Body")

Set object = body.EmbedObject( 1454, "",Curdir()+"\"+"temp"+".doc")

Set Hdl=object.Activate(True)

’ Call object.DoVerb(“&Ouvrir”)

Call doc.save(True,True)



Set word_app = Nothing

Set activedoc = Nothing

======

if it’s help anybody or myself…

4

Subject: Word, Excel, Project, VISIO docs attached to Notes docs

If you’re all on the same LAN and can see the same drive, in your case F: drive, you can use hotspot. Type your link in an email, copy it and leave it highlighted, click on Create-Hotspot-Link Hotspot and paste the link into URL field. That opens the same file every time. Attaching a file creates a new copy of the file.

Ryan