PDA

View Full Version : Auto Extracting Recording From RTF to EXCEL using VBA



Dasein
01-28-2013, 01:19 AM
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
01-28-2013, 06:31 AM
I would merge all those rtf files into 1 to start with:

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