export each Inv number to excel sheet

[jln via AccessMonster.com]

I have a table that has multi records that are tied to INV numbers. What i
need to do is for each Inv Number i need to export to a new work book and
save each work book with the Inv number that is being exported.