txt to xls via macro

[DMC]

Hi everyone, I am new here, First Post. Here it goes...

I open and format a txt file via a macro, now I want to do
a save as (unique file name everytime) to a specific
folder, if the folder does not exist, I would like to
create the folder. Is this possible??

If not, could someone just show me how to save a txt to
xls to C: via a macro??

Thanks in advance