PDA

View Full Version : File name from multipe cell contents and prefixed filename



Chandler
02-10-2010, 03:49 AM
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
02-10-2010, 12:03 PM
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