How to loop through a specific folder of workbooks
Posted by Richard O'Brien on February 29, 2000 8:49 AM
I want to construct a macro that will loop through a specific directory of similar workbooks, extract about 30 cells of information from a specific worksheet within each workbook, place the values in these cells (which are calculated) sequentially in a new worksheet (in a new workbook) and save it as a txt file with an IIF extension for import into Quickbooks. Many tries, no success. Ugh!
Thanks in advance for any support