Results 1 to 2 of 2

Thread: File name from multipe cell contents and prefixed filename

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    File name from multipe cell contents and prefixed filename

    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
    Last edited by Aussiebear; 04-10-2025 at 03:35 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •