O
Owen
'Try This...
Sub SaveName()
Dim strPath As String
Dim strFile As String
Dim strDate As String
strPath = "C:\Temp"
strFile = Sheet1.Range("I3")
strDate = Format(Now(), "mm-dd-yyyy")
ActiveWorkbook.SaveAs FileName:=strPath & "\" & strFile &
strDate & ".xls"
End Sub
written part is already complete.
cell, (I3), and then add the date proir to saving the
file.
Sub SaveName()
Dim strPath As String
Dim strFile As String
Dim strDate As String
strPath = "C:\Temp"
strFile = Sheet1.Range("I3")
strDate = Format(Now(), "mm-dd-yyyy")
ActiveWorkbook.SaveAs FileName:=strPath & "\" & strFile &
strDate & ".xls"
End Sub
current date attached at the end? Command Button is-----Original Message-----
An easy one for excel experts!
1. I need to save a file from a command button with the
written part is already complete.
cell, say I3. I want the button to use the name in the2. I would like the name the file to be entered into a
cell, (I3), and then add the date proir to saving the
file.