Sending information from Access to a specific cell in excel.

G

Guest

My work has created a spread sheet in excel to submit expense reports by. I
already have a database in access that I track this information. I would like
to test each row in access and send that information to a specific cell in
excel.
docmd.transferspreadsheet will not work because it does not allow you
to send the information to a specific cell. Is there a way to programmaticaly
send a piece of information to a specific cell in access....IE...myLunch =
excelCell(1B).
 
V

Van T. Dinh

You will have to use Automation code. You can use VBA code to open Excel
application then your excel file and then assign values (from your database)
to particular cells in the spreadsheet.

Check Access Help on Automation. I think there are a number of articles on
the MSKB on Automating Excel from Access:

http://support.microsoft.com/search/Default.aspx?adv=1
 

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

Populate cells in an excel spreadsheet with information from an access database 1
Access 07: How to pull in information 4
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Help with Importing from Excel into Access 0
How can I import an unstandard Excel worksheet into Access 2007? 3
follow hyperlink to excel cell with specific value 1
Access Database & preset report/form 9
Link Access to Excel export back to excel 3

Top