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