W
wimblebury
Guest

I really need to find a way to run a bit of code which exports a Access query to excel and automatically saves the workbook.
However it is not quite so straightforward - I need the code to create different workbooks based on the contents of a field within the query which will be duplicated (it is actually a school name and several hundred pupils will be attached to a school) and use this field (schoolname) as the excel filename.
It needs to be at a click of button - the code runs creates loads of different workbooks and then says done!!!
Please Please Help Me.