Thanks Bob it worked great



Bob Phillips wrote:
You have the closing bracket in the wrong place

sFilename = "C:\TimeSheet\" & _
Format(Range("h12").Value, "mm-dd-yy Job# ") & _
ActiveSheet.Range("h2").Value & " " & _
Range("b6").Value


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ward376" wrote in message
oups.com...

Try changing the last .value to .formula.