I need an application program (.exe and source) or Excel VBA to read a sequence of Excel files and extract specific information from each file.? The program should:? read a file, extract the specific information from a single worksheet, output the information to four different Excel worksheets based on a commodity title (i.e., wheat, corn, oats or soybeans), read the next file, extract information and append it to the correct worksheet to build a database, etc.? Note that the files you will read are all saved in the Excel 1997-2003 worksheet format, but if you write a macro for Excel, it should work in the Excel 2007 version; that is, the macro should run in Excel 2007 with the output produced in either 1997-2003 or 2007 formats??"I don’t care which format you use for the output file.
I’ve included a sample set of Excel files for download, which in practice will be in the same folder. On each of these files, I’ve highlighted the information to be extracted.? I’ve also provided an example of the output file/database structure that is required. ? The output file shows you the layout and the specific data that must be extracted. Also note that if there are blanks in a number field the entry is to be are coded as a zero; however, if a date field is blank, leave it blank.?
An initial DEMO in your response increases the chance of being selected.