File save name to populate

Hi,

I am beginner in vba coding.
Could some one please help me with 'how to populate new file name as sheet name' ? Thanks in advance.
my macro code is as below:

Please Login or Register  to view this content.

Please follow the forum rules.

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:

Please Login or Register  to view this content.

... and appear like this when posted:




your code here ...
and here ...
and here
You can also type the code tags in manually if you prefer. For more information about these and other tags, click here.