How do I loop through a folder, import only the data from A5:LastRow and kill each file?
Posted on 2015-01-07
I have a folder of formatted macro enabled spreadsheet forms with multiple tabs and data to import and append to an Access 2010 table. The top 4 rows of the target tab are a header that can be excluded from the import, so what I want to do is grab everything on that one tab from A5 to the bottom, which is different in each file.
I want to loop through the folder, import and kill each file after the import. Does anyone have a chunk of code for that?