Save workbook based on cell value in different sheet

[marcus314]

Hello,

I'm wishing to save a new workbook based on a cell value in a different sheet. I was able to get this to work based on the cell value of the active sheet, but when I try to reference a different sheet, I get an error. Considering I'm still new to learning VBA syntax, this isn't surprising!

The key excerpt of the code is below:

.SaveAs ThisWorkbook.Path & Application.PathSeparator & "R-" & Worksheets("File Namer").Range("D1").Value

Any ideas?

Thanks!

 

[JoeMo]

What error do you get? Is it on the line you posted? What's in cell D1 of the sheet File Namer? Is that line part of a With-End With construct? If yes, can you post the entire construct?