I learned how to rename workbook without saving it
"Don Guillett" wrote:
What is wrong with saving it? Then you can use NAME to change again, if
desired.
Wrong with saving is task i had to solve. And the task (sorry, i didn't
describe it before) is to generate report, then give it to user to do with it
whatever he wants.
If I give with default name, he must rename it manually. (So it worked
before task grown - name file with some specific name plus date plus time).
The users a 1) Lazy 2) Inattentive. Result of those two user.mind
attributes is that he didn't do it never.
If I save the file in usual (not temp) directory, it very soon is full of
garbage. User will never delete file which he have no need.
If I save the file in temp dir, and user forget to save it in non-temp dir
(and he, of course, forget it), he never find it in those tons of crap which
fills the temp dir.
|