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. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,446
    Location
    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
    Last edited by Aussiebear; 04-10-2025 at 03:36 PM.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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