Assigning data to specific cells in excel from access

[King]

Hi guys
I have an access database with several forms. One from prompts the user for landholder details and has command buttons to open another form with property assessment details. once the second form is complete I have a command button which opens excel and assigns the property ID number as the sheet name. What I want to be able to do is put the landholder details into specific cells in the sheet automatically (similar to the way the sheet is named) Is it possible to do this from access.

Cheers

 

[Norie]

a command button which opens excel and assigns the property ID number as the sheet name

What code is doing this?

Can you post it?

 

[mdmilner]

There's a couple different ways to approach this:
One, if the cell locations never change might be to code the locations into an Access function (that you write) to save specific data to specific locations.

A second, if it's always the same way, (lets say you want to save the data exactly as it appears in a table (or re-ordered as it appears in a query) - you can export the entire query to a given table.

A third is similar to the first. You can export specific data to a named range on the xls. This allows you to rename groups of cells without the Access MDB needing to know anything about it.

This isn't going to answer your question, but here are some technique examples.

http://www.mvps.org/access/modules/mdl0035.htm

Mike