automatic export with layout in excel....

I want to create an excel document from data in access.
each data has to have its own specific cell place in excel.
Is there a option available to make this work?, or is VBA the answer?

re: automatic export with layout in excel....

You can have complete control on exporting to Excel including formatting
cells and ranges. It is a long VBA process, but try creating a macro in
Excel and then pasting the code into Access. If you get stuck, I can post
you an example, but it is specifically for my application. It may however
give you some clues

HTH

Phil


"Joost de Vries" <joostvries@gmail.com> wrote in message
news:1130830789.191099.313950@g44g2000cwa.googlegr oups.com...[color=blue]
>I want to create an excel document from data in access.
> each data has to have its own specific cell place in excel.
> Is there a option available to make this work?, or is VBA the answer?
>[/color]