Save worksheet as seperate workbook problem- File name issue

I am using the following code attached to a button to save the worksheet as a seperate workbook. The problem I have is if I try to use a range for the filename then the code crashes! Should be simple but cant get it to work?

Please Login or Register  to view this content.

If I replace this line:

Please Login or Register  to view this content.

with this line I thought it would be that simple?

Please Login or Register  to view this content.

But then it doesnt seem to like this:

Please Login or Register  to view this content.

would be nice if I could also add the date and time to the file name so multiple copies can be saved without overwriting, is this possible?
Hopfully someone can help me
Thanks
Andrew