Re: Export to excel in different tabs depending on criteria

Thanks for the link, however I am not sure how to use the information there
for what I need to do?? It talks about named ranges, but the workbook that I
want to copy to will be a new workbook each time I export and so will not
have named ranges. Also, the sheets that I want named in the workbook, copied
from the [JOB REF] field are likely to be dynamic too.
--
K Hogwood-Thompson


"pietlinden@xxxxxxxxxxx" wrote:

On Aug 13, 10:40 am, KHogwood-Thompson
<KHogwoodThomp...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi,

I have a query called "CVR Movement", this contains various transactions
against various [JOB REF] codes. I want to export the data to Excel and would
like the data put into different tabs on the file which is retrieved from the
[JOB REF] field. Can this be done in code? If so, where does this need to go?
I have Office 2000 if it makes a difference at all.

Thanks
--
K Hogwood-Thompson

maybe this will give you some ideas:
http://www.mvps.org/access/modules/mdl0035.htm

.