View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Yar Glazkov[_2_] Yar Glazkov[_2_] is offline
external usenet poster
 
Posts: 9
Default 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.