Naming A WorkBook To Be Saved.

I've tried to include the following code along side strDestName so that it saves the workbook as today's date using

Please Login or Register  to view this content.

but there must be a syntax error somewhere.

Here's the original code

Please Login or Register  to view this content.

Eventually, what I'd like to acheive is for the strDestName to be named with the text input by the user into a particular cell or better still a text box control, followed by todays date.


As I only have a basic grasp of coding, VBA, if anyone is kind enough to help out it would be great if comments were added into the coding with a brief explanation of what the codes doing.

Your code works fine for me.

Are you able to save files to your desktop?

Originally Posted by mojo249

Your code works fine for me.

Are you able to save files to your desktop?

Yes, I can save to my desktop but as soon as I try to incorporate Format Now etc the coding errors!!!

Can you show me exactly how you incorporated the additional coding as no matter which way I add it I can't get it to work?