Summaraizing many files
Posted by Alexia on December 31, 2001 11:16 AM
Is there a way to write a macro in a summary workbook that would pull in information from all the NEW files in given directories. An example would be for purchase orders. I want to pull in the field for PO number, vendor, amount and then add a link to the file. Then I want to be able to run a macro once a week or so, that will add a row for each new file, pulling in this same info. Perhaps the link could be the determining factor. Sounds complex, I know.
Or, if I manually entered the PO numbers (they're sequential numbers) in the summary, could I then setup a macro to look for any new files whose name contains this PO number and either fill in the info I want or if there is none, leave the cells blank.
Any direction would be much appreciated. Thanks :-)