VBA auto email problem

[merrillsteel]

I'm trying to creating a command button to auto send the active sheet in an email. The VBA works intermittently, when it fails debug hits this line in the code.

WB.SaveAs FileName:="C:" & FileName, FileFormat:=xlOpenXMLWorkbookMacroEnabled

The error I get:

Run-time error '1004':
Microsoft Excel cannot access the file 'c:

Thanks

[Logit]

.
Untested ... but my first thought is the "backslash" is missing : WB.SaveAs FileName:="C:\"