Hi,

Was wondering if anybody could help.  In the Initialise_Form subroutine of a
word macro, I would like to read data (a number) from a single cell in
Excel, insert it as the caption of a label box (so that the data cannot be
altered by the user), then add 1 to the number in the cell in Excel and save
the worksheet, all without opening the worksheet.  This will ensure that
each time the form is initialised, it will have a unique number.  The reason
why I would like to use Excel is that there will be a number of users
initialising forms.  I have seen the excellent tips on the MVP website (and
have used them to load a listbox from an excel range for another part of the
form), but cannot find anything directly on point.  I would like to know
whether saving data to a closed Excel file can be done.  Any help would be
appreciated.

Many thanks,

Kym