Outputting to Multiple Excel Files (some containing multiple sheets)

[raychase]

Hello,

I recently got some help outputting my data to multiple excel files, and some of those files contain multiple sheets.  The single output tool is set up to "overwrite sheets" and is grabbing the entire path name from a field in my data.  Unfortunately, sometimes my files with multiple sheets get written at the same time and I get errored out due to locked files.  I understand I can get away with this using a block until done tool, but I have a lot of files being generated (20+), and some of them have 5+ sheets.  Is there a way to efficiently make use of the block until done tool?  Do I need an iterative macro?  Is there another way around this error?  Please help!

Thanks.

[DavidP]

Brilliant! Really happy that you got it working