Include current date in filepath

Here is my current code:

Please Login or Register  to view this content.

The workbook is saving as Bassani_ & Left(Now(), 10).xlsx rather than Bassani_04142015 which is what I need it to do. I'm trying different ways but I can't seem to get the naming right. Everything else works fine

Try below:

Please Login or Register  to view this content.

Oops. Revised below:

Please Login or Register  to view this content.