I have a single spreadsheet that has 20 worksheets in it. I have code that extracts a Workbook for the file, for each worksheet. That code worked, until I tried to process more than 18 worksheets. Then, I got the error "You are using an evaluation copy and have opened files exeeding limitation.".
We do not have an evaluation copy, we have a license purchased Aug 2013.
The loop in my code that is processing each worksheet creates a new Workbook(FileInfo), which is stored in a local variable, which goes out of scope at the end of the loop. When I process any 18 of the worksheets, everything works. As soon as I try to process a 19th worksheet, I get the error. That makes me think some resource is not being released, but I don't know what it would be.
Could you please assist with this?