By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,310 Members | 1,885 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,310 IT Pros & Developers. It's quick & easy.

automatic export with layout in excel....

P: n/a
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?

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <jo********@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
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?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.