Consulting

Results 1 to 2 of 2

Thread: Sleeper: Copy Paste as Values & Save as new sheet

  1. #1

    Sleeper: Copy Paste as Values & Save as new sheet

    Hi there,
    I'm very novice with VBA, so any help with the below would be much appreciated!
    I am trying to copy all the values in a worksheet ("Sheet2") and then paste them as values into a new spreadsheet and then be able to save that new spreadsheet with a file name that is equal to the value in cell A1.

    I've found the below code for the latter part of the request. I also created the first part, but am not successfully able to join the two.
    Any suggestions?

    Option Explicit
    Sub SaveAsExample()
    Dim FName As String
    Dim FPath As String
    FPath = "C"
    FName = Sheets("Sheet1").Range("A1").Text
    ThisWorkbook.SaveAs Filename:=FPath & "\" & FName
    End Sub
    Last edited by Sharbucks; 12-19-2016 at 01:15 PM. Reason: fixed title

  2. #2
    FPath = "C://..."***

Posting Permissions

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