Exporting to an Excel Form

[JohnM]

I have a question. Can data be exported to an Excel form?
The scenerio is this: Need to export data from a query to
a pre-existing excel form the form contains headers,
formulas, and formating. We have clients that are
requesting their invoices be in Excel format, we now have
to type in manually. I want to automate this function. I
know how to export to an Excel file but cannot send it to
a specific range of cells. Can this be done. Using Office
2K.
Thanks in advance fro any assistance.
John Miller

 

[John Nurick]

Hi John,

When you need full control, IME it's usually best to work by using VBA
code to automate the Excel object model: this lets you manipulate
individual cells in the worksheet. See

This is a useful article giving the basics of controlling Excel from
Access: "Sample Excel automation"
http://www.mvps.org/access/modules/mdl0006.htm

This article "Methods for Transferring Data to Excel from Visual Basic"
http://support.microsoft.com/default.aspx?scid=kb;en-us;247412 explains
several techniques; most of it applies to VBA as well as VB.