Exporting to an Excel Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JohnM - 13 Aug 2004 15:24 GMT

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

Reply to this Message

John Nurick - 14 Aug 2004 14:36 GMT

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.

>I have a question. Can data be exported to an Excel form?
>The scenerio is this: Need to export data from a query to
[quoted text clipped - 7 lines]
>Thanks in advance fro any assistance.
>John Miller

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message