Auto Extracting Recording From RTF to EXCEL using VBA

[Dasein]

Hi guys, I am a new comer who is not familiar to VBA but have some experience in JAVA and SQL.

I have a bunch of RTF files which will be more and more from time to time. In each RTF file, there will be some information that I am interested in, so that I have to code a VBA to auto-collect such important information from each RTF file.

Although it may not be necessary, I am considering recording each RTF file by a unique cell. Hence, hopefully I will have a sheet of excel with 2 columns, ID and a extracted RTF content.

Afterward, I will code another macro to extract useful information from each RTF content cell to another sheet. My goal is generating a database like excel sheet by using to 2 macro.

Hence, I have a problem.
1) I would like to ask if I can do auto-extraction? I would put my excel and all the RTF files in the same folder.

[snb]

I would merge all those rtf files into 1 to start with:

[vba]sub M_snb()
shell "cmd /c copy G:\OF\*.rtf G:\OF\gesamtkunstwerk.txt",0
end sub[/vba]