File name from multipe cell contents and prefixed filename

[Chandler]

Good morning

I'm very new to using VBA.

I'm currently making a spreadsheet for each of our clients, and to save time, I'm looking to create a VB module to allow information in cells to be used as the filename.

Currently, I have found the following:

Option Explicit
 
Sub SaveAsExample()
    Dim FName As String
    Dim FPath As String
    FPath = "C:"
    FName = Sheets("Sheet1").Range("C10").Text
    ThisWorkbook.SaveAs FileName:=FPath & "\" & FName
End Sub

Ideally, I would like it to present:

C11 C10 - Individual Learning Plan 0910

I would like it to allow me to use at least 2 cells in the Range for the client ref number and also their name. I would also like a prefixed filename after this.

Any assistance would be greatly appreciated

[Bob Phillips]

Sub SaveAsExample() 
    Dim FName As String 
    Dim FPath As String 
    FPath = "C:\" 
    FName = Sheets("Sheet1").Range("C10").Text & " " & Sheets("Sheet1").Range("C11").Text 
    ThisWorkbook.SaveAs FileName:=FPath &  FName & Format(Date,"ddmm")
End Sub