• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Auto Name and save with field input

RJWrookie

New Member
I have a template that I use to prepare quotes, but when I am busy or have 2 or more clients I am working with I cannot open a second template without going through several steps (Save as, select folder, rename).

I need a code that will automatically rename the file once cell c3 is entered (name of client) and auto save in a predetermined folder. C:\Desktop\Prospectives

Any ideas?
 
Drop this into the worksheet's code module...
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$C$3" Then
        ThisWorkbook.SaveAs "C:\Desktop\Prospectives\" & Target.Value, 52
    End If
End Sub
 
Back
Top