N
NickH
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
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