Thread: Saving with name and date macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Simon Lloyd[_39_] Simon Lloyd[_39_] is offline
external usenet poster
  
Posts: 1
Default Saving with name and date macro

Without specifying a path this will save in My Documents:

Code:
--------------------

ActiveWorkbook.SaveCopyAs (ActiveSheet.Range("B5").Value & " - " & Format(ActiveSheet.Range("B6"), "dd - mmm - yy") & ".xls")


--------------------


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35583

Reply With QuoteReply With Quote