Like so:
Sub SvMe()
'Saves filename as value of A1 plus the current date
Dim svPath As String
Dim newFile As String, fName As String
'assemble save path string
svPath = "C:\QUOTES\" & Range("O3").Text & "\" & Range("O4").Text & "\"
'create directories if needed
Call MakeFolders(svPath)
'Don't use "/" in date, invalid syntax
fName = Range("O2").Text
'Change the date format to whatever you'd like, but make sure it's in quotes
newFile = fName & "_" & Format$(Date, "mm-dd-yyyy hh mm AMPM")
'Save it
ActiveWorkbook.SaveAs Filename:=svPath & newFile
End Sub
Function MakeFolders(MyStr As String)
'Author: Jerry Beaucaire
'Date: 7/14/2010
'Summary: Create directories and subdirectories based
' on the text strings fed to the function
' This version is to be called by other macros
Dim MyArr As Variant
Dim pNum As Long
Dim pBuf As String
On Error Resume Next
MyArr = Split(MyStr, "\")
pBuf = MyArr(LBound(MyArr)) & "\"
For pNum = LBound(MyArr) + 1 To UBound(MyArr)
pBuf = pBuf & MyArr(pNum) & "\"
MkDir pBuf
Next pNum
End Function
This is based on the code published here:
Make Folders and Subfolders
Bookmarks