VBA code to use specific cell's text as file name

[appleglaze28]

I was wondering I'm new to VBA coding so I'm kinda looking for help. I have this excel template that I need to generate a text file in...just so I can identify the files, I want to use a specific cell's text as its file name as well as the date when the text file was generated. How can I make this possible?

[wamp]

right-click on a sheet and select "view code"
in "Thisworkbook" paste this code:

Please Login or Register  to view this content.

_______________________________________________
Hope this helps

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of their post to show your appreciation.