Export Cells to Text and automatically have File Name and File Type Selected

What I am trying to accomplish is saving a range of cells to a text file titled "CONTENT" but I want the user to decide where to save the file. I currently have a code that exports the cells to a file and a save as box pops up - the user then has to title the file, select file type and where to save the file - I'd like to have the file name and file type already selected. Hope that makes sense. Below is the code I am currently using. Any and all help is greatly appreciated. Thank you!

Please Login or Register  to view this content.

Thanks so much for your reply!! I tried this and all it seems to do is resave my whole excel file. I am on Excel on a Mac. Could that be an issue?

Than

It does the same thing as before, just saves my current excel file. No box pops up. Here is where I plugged it into my code. Maybe I'm not placing it in the correct spot?

Please Login or Register  to view this content.

Thanks!! It does have a save as window pop up and Content is filled in for the file name but the file type is not set to text. Is there a way for that to happen?

Thank you!!

Ok. No worries. Thanks for the help!