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:
[vba]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
[/vba]
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