Sequentially numbering a word document on SharePoint

[DJK]

I have a word template on SharePoint and would like to set it up to
Sequentially number each form. The code to call a file from the C: drive is


Order = System.PrivateProfileString("C:\Settings.Txt", _
"MacroSettings", "Order")

But a SharePoint link does not work with System.PrivateProfileString - Can
anyone tell me what to use when I need to call the file in SharePoint. (
http://us-team-it.hereIam.net/sites/gesfa/BEN/ChangeRequest/PMIS Change Request/Forms/Settings.txt)

 

[Doug Robbins - Word MVP]

You will need to have a file somewhere that is accessible in which you can
store the last number used. One way that I can think of would to be to use
a Document Variable in that file that you accessed when creating a new form
to get the number that was stored there, add one to it to use in the new
form and write the new value back to the document variable and save the
document in which it is located.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[DJK]

How would you call the number from the document into the field? Is there a
way to use the system method from a SharePoint file?

 

[Doug Robbins - Word MVP]

Dim log As Document
Dim Lognumber As Long
Set log = Documents.Open("C:\log.doc")
With log
Lognumber = .Variables("Lognumber").Value + 1
.Variables("Lognumber").Value = Lognumber
.Save
.Close
End With
'Lognumber now contains the number for the next form



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP