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.
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.