Run-time error 1004/Save file macro

[egglee]

I am trying to set up a macro in a template that when run will set the filename and file path and save as a macro enabled document. What I need to include in the filename is text from C7 and the date from C9 e.g. 4 June 2013

Have used the following code

Please Login or Register  to view this content.

When I run the macro I get the following error (the second line as highlighted above seems to be the issue).

Run-time error 1004
The file could not be accessed. Try one of the following


I hope this all makes sense, because I am very much a noob when it comes to vba

Thanks

[nathansav]

what is in C7 and c9 when you get the error

[egglee]

A first and last name

[nathansav]

can you show me exactly? Is c9 todays date?

[egglee]

C7 John Smith
C9 4 June 2013

[nathansav]

You don't need the XLSM and you need to use the .text for the date

Please Login or Register  to view this content.

[egglee]

You are awesome thanks so much