Does anyone have any guesses as to why my Excel 2000 template might be
crashing, with an automation error, when it tries to save a workbook
with a filename longer than 58 characters (including extension)?

Bizarrely the workbook will have originally been created and saved by
the same template - the filename having been derived from information
provided by the user at startup.

Now I have built an upgrade facility into the template so that old
workbooks can have their data pulled into new copies of a modified
template. It is after upgrading and then saving a backup copy of the
old Workbook and/or the upgraded copy that Excel decides to get fussy
about the length of filename.

Anybody any clues?

NickH