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



"Patrick Molloy" wrote:

you're not reaming the workbook. You're simply changing the default name ...
so you'll still get {default}1 .. 2 and so on. This doesn't resolve the
original query though.
Good try!



Thank you, but you are wrong :-)
That way I change {default} with whatever I like. The thing you're right is
that I cannot change the directory (of future saving the file) with this
approach.