Multiple excel exports

[BSando]

OK. I'm sure this can be done . I just can't get my head around it.
I have a query I want to export to excel. But I want to export each individual query record to a new workbook called after on of the field names.

Some people make things happen, some watch while things happen, and some wonder 'What happened?'

 

[Blorf]

You will need a little VBA.

Post your SQL with a little sample data and I will write a very short routine.

ChaZ

"When religion and politics ride in the same cart...the whirlwind follows."
Frank Herbert