View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
a94andwi
 
Posts: n/a
Default saving file name based on value in predetermined cell


Hello.

I need a macro that copies a range to a new workbook and saves the new
workbook with a predefined name.
The predefined name should be like "name current date.xls".
I know how to create the first steps but I don't know how to use the
predefined name.

I saw this question and it might be a good place to ask this question
or am I wrong?

Please help.

/Anders


--
a94andwi
------------------------------------------------------------------------
a94andwi's Profile: http://www.excelforum.com/member.php...o&userid=21077
View this thread: http://www.excelforum.com/showthread...hreadid=541891