Thanks a lot sir. It works perfectly.
*Thanks,*
*Nilkanth Raval*
*+91 900 428 0 428*
*+91 808 000 1620*
*Think Before You Print.Consider ENVIRONMENT.*
*“SAVE TREES, SAVE EARTH” *
*“All appears to change when we change!”*
On 6 February 2015 at 00:42, Paul Schreiner wrote:
> The problem is that
The problem is that the first time a duplicate is encountered, instead of
ADDING it to an existing workbook, you're trying to create a new one.
Instead, I'd wait until they're all done before closing the workbooks.
Then, within the code, only create a workbook if it isn't already open.
I'd mod
