locked
workbook save as using cell for filename RRS feed

 > 

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    As far as I understand you want to save a workbook with a name specified in the cell. Am I on the right avenue?

    The SaveAs method of the Workbook class should be used for saving changes to the workbook in a different file. To get the filename you can use the following code (the Text or Value property of the Range class):

    Worksheets("Sheet1").Range("B14").Text

    • Marked as answer by George Hua Wednesday, February 19, 2014 4:30 AM
    Tuesday, February 11, 2014 8:06 PM