Save file with certin Criteria

[parteegolfer]

I am looking at a given point to save a workbook with cetain critera. What I want to do is save a workbook and get some value from a given cell then save it.

Example: I want to save a workbook with the name:

ActiveWorkbook.SaveAs Filename:="C:\Service Recaps\John Mudaro_(Here I need the value from Worksheet "Data",Cell C5).xls"

Can anyone Help?

[raypayette]

n = Cells(5, 3).Text
ActiveWorkbook.SaveAs Filename:="C:\Service Recaps\John Mudaro_" & n