office templates to automatically fill in reference numbers

[Sajid Saeed]

hi,

I would like to create an office template (word or Excel), that will
read the last serial number from a file, and place this number in the
appropriate field in the template?

anybody done this, and how can it be done?

Sajid Saeed