Here’s another approach that won’t require using the Excel object model. Create all the individually filtered tabs in a single .rep file, then save the result as Excel. There is some code here that can get you started … Create report tab and filter for each value. Add the piece that saves as Excel, then DON’T save the .rep file itself.
Dwayne Hoffpauir 
(BOB member since 2002-09-19)