New workbook from xlsm to xlsx, same location different name?

Hi all, I'm trying to create a sub, that if we press the command button we assign to it will create a new workbook for us which is not a an xlsm but an xlsx and is saved to a the same place where my current workbook is, but under a different name, which would be "My_New_Report" and the current date as DD-MM-YY, and the new workbook should have Sheet1 (Code name) and Sheet4(Code name) copied over into it.

But this code doesn't seem to work:

Please Login or Register  to view this content.

Compile error expected end of statement and the "My_New_Report" is highlighted (Including the doublequotes)

Please help!

Made it work!

Please Login or Register  to view this content.