Save as a new format name automatically

[Tom]

Hi,

I am using a macro that enables me to open text files one
after another automatically. Each file contains many rows
of comma delimited data like,

ABC,20100611,2.76,2.79,2.7,2.72,1704614
-------------------------------------------------
-------------------------------------------------
XYZ,20100611,4.9,4.36,4.79,4.22,3418135

The files themselves are named after its content date like
20200611.txt. The macro then extracts some wanted data to
another file, closes down, opens the next file 20100612.txt and
repeats the process. Before it closes, how can I modify the macro
to make it save each one of them with a new format name, like
20100612.csv? - i.e. the save as command needs to use the first part
of the name of the file that is currently open. Thanks for any help.

TIA
Tom

 

[Don Guillett Excel MVP]

As ALWAYS, post your code for comments. Look in the vba help index
for SAVEAS

 

[Tom]

As ALWAYS, post your code for comments. Look in the vba help index
for  SAVEAS




- Show quoted text -

What came before is irrelevant. The macro must be able to:
1. Read the the "activefile name".
2. Save it with a .csv format.

Tom