Hi Softrak

I don't know how using the /XDP parameter will accomplish what the client wants. The accounting clerk is logging in with her ID, and wants to generate 10 separate spreadsheets/reports, one for each salesperson, each in a separate folder. The idea of her having to log out and in 10 times with a different ID each time is not very appealing, and certainly does not fall under the category of "automatic".

So I guess I'm still soliciting ideas.

One idea that comes to mind is to write an Excel macro (using Virtual Basic?) that takes an unfiltered spreadsheet that GridView can write to the XDVIEWS folder, and divvy it up into 10 spreadsheets/reports (maybe using the Data Filter function). But I don't know Excel well enough to write the macro. Does anyone out there think this can work?

Thanks

Steve