Problem looping through multiple files to copy/paste into master workbook

Hi all,

The following code has been a work in progress. Basically it looks at a summary sheet for a day's worth of salesperson's invoices, looping through up to 40 invoice "lines" and then loops through another series of lines for payment information. I have been able to run this code selecting one file at a time. Since I run this daily on up to six files, I tried adapting some code to loop through multiple files. The code hits the error handler and tells me no file was selected (even though it opened the first file). I would greatly appreciate any help if someone can spot why this happens.

Thanks in advance!

Please Login or Register  to view this content.

In my case the error is triggering because is trying to assign the workbook "All Invoices Master.xlsm" and of course that workbook is not open.

Its possible you have an incorrect error...the handler is built wrong...
correct to below to see REAL error:

MsgBox Err.Description, , Err
'MsgBox "No file was selected."

Ok I think this will solve your problem, JUST MAKE SURE THAT THE WORKBOOKS YOU ARE OPENING ALL HAVE THE SPECIFIED SHEETS.

Please Login or Register  to view this content.

Let us know,

Thank you both for the quick replies. I run the macro from the "All Invoices Master" file so it is open. Sorry, I should have clarified. For accuracy sake, I will fix the error handler, too.

I actually just figured it out - the next reference in the code to FileName needed the subscript (j) included, and now it works.

Thanks again!

Exactly! Please don't forget to close post as solved and add reputation in case any of the members help you in any way