Thread: use part of date in cell for save as name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_2_] Patrick Molloy[_2_] is offline
external usenet poster
  
Posts: 1,298
Default use part of date in cell for save as name

fullfilename = "C:\ToCav" & format$(day(Range("A1")),"00") &
format$(year(Range("A1")),"00")



"Helmut" wrote:

I have date in "A1" = 28/02/2008
I want to save worksheet as:

"c:\ToCav0208m.csv"


Reply With QuoteReply With Quote