Help with VBA that pulls data from another workbooks

I am new to the forum, but would like to express appreciation for any help in advance. I came across the following post as I tried identifying a solution to my problem:

http://www.excelforum.com/excel-prog...ther-file.html

I have sheets that are being created daily as well, and I want to copy the data over to a master sheet to keep a daily record of the totals generated from the query that is generating the daily Excel files.

I copied the code from the above mentioned post and tried modifying it for my specific use. The macro runs, but returns an error saying that the file was not processed. I am pretty novice with VBA and am trying to troubleshoot the code to see what additional changes I would need to make for it to function properly. I am not sure, but I think it may be something involved with either the date format or the name of the file being processed. Nonetheless, I 'd rather ask for help than scratch my head forever.

I have attached two files to help show what is taking place.

Also, here is a copy of the code with the changes that I made:

Please Login or Register  to view this content.

Thanks again in advance

First off correct your fDone string, notice the / at the end is going the wrong way...:

.....\Processed/"

Next, the macro is looking to test the fName to see if it's a date, proceed if it is. Your filename HAVE a date in them, but they aren't a date. So you'll need to remove that part, or change the test.

The only need for a test is if there are other files in that folder to ignore. If not, take that IF test out and just process those files found.

I think you can leave the names of the files alone, if they always start with ToadExport that can be removed explicitly, or at least the date immediately after can be found easily.

1) Remove all code trom ThisWorkbook module. That module is for workbook level event code, not on-demand macros like this.

2) Add an empty standard code module (Insert > Module), then paste in this new version of the macro:

Please Login or Register  to view this content.

Notice my fPath and fDone strings end with a \ while the code I found in the wb you uploaded did not.