export to specific cells in excel

T

tracey

I need to export data from access to specific cells in an
excel spreadsheet. any idea where I can get more info on
this?
 
J

John Nurick

Hi Tracey,

You'll need to use VBA and Automation. The following links should get
you started:

Sample Excel automation
http://www.mvps.org/access/modules/mdl0006.htm

Q123859 ACC: Sample OLE Automation for MS Word and MS Excel
http://support.microsoft.com/?id=123859

ACC2000: Using Automation to Create and Manipulate an Excel Workbook
(Q210148) http://support.microsoft.com/?id=210148

ACC: Using Automation to Create and Manipulate an Excel Workbook
(Q142476)
http://support.microsoft.com/?id=142476

There's a white paper and code samples including tutorials available
from Microsoft at
http://support.microsoft.com/?id=253235

Also, search www.mvps.org/access for Excel Automation
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Integrating information from Word to Excel (not mail merge) 1
Crating User Form to Add Names 1
How to export html text as word document with specific size and orientation 0
Cell data entering slow! 0
Creating a Chart on form from selected data in query. 0
Need Help with a VBA subroutine 0
Using Office Forms and dynamically updating the excel backend 0
Using Access Database to build contracts with fields on pdf document 0

Top