Thread: Save Location - Date Format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_3_] Dick Kusleika[_3_] is offline
external usenet poster
  
Posts: 599
Default Save Location - Date Format
Ravi


MyFileName = "Date" & Me.TextBox1.Text & ".xls" 'Create the
File Name

MyFileName = "Date" & Format(Me.TextBox.Text, "yyyy-mm-dd") & ".xls"

Please post to only one group.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.



Reply With QuoteReply With Quote