locked
workbook save as using cell for filename RRS feed

Answers

  • 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