Exporting to an Excel Form

  • Thread starter Thread starter JohnM
  • Start date Start date
J

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
 
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.
 
Back
Top