Want to capture Remarks/Notes on Dashboard which can be stored and made available to users.

[#1]

I am using version 8.2 and i want to capture remarks by users which can be stored back in database or excel fle and later being displayed for others user after the upload.

Can someone pls. suggest me how to do so.

Thanks and Regards,

Ashish Sharma

[#2]

I am assuming you just want to save some general comments rather than against certain rows (in later versions you can use inputfield).

You can have an input box tied to a variable and after the user has entered something you could run a macro (perhaps as a trigger on the variable value changing or the user pressing a button) to save their input. The following macro should give you some ideas (it updates a log of some downloaded data):

set doc=ActiveDocument

vExportLog = doc.Variables("vExportLog").GetContent.String

set fso = CreateObject("Scripting.FileSystemObject")

on error resume next

set logFile = fso.GetFile(vExportLog)

if err <> 0 then ' file does not exist
on error goto 0
set logFile = fso.CreateTextFile(vExportLog)
set logFile = fso.GetFile(vExportLog)
else
on error goto 0
end if

set txsStream = logFile.OpenAsTextStream(8) ' append
txsStream.WriteLine Now & " " & vExportTo & " created by " & doc.GetProperties.FileName
txsStream.WriteLine Now & " " & vExportTo_1 & " created by " & doc.GetProperties.FileName
txsStream.Close

Regards,

Gordon