access completing an excel worksheet

[doobr1e]

i am looking at using access to complete and email an excel spreadsheet
form many times over once the data entry has been completed in access.

initial question is will i use access to complete fields in an excel
spreadsheet or will access create the spreadsheet or can it do both (im
completely fresh to access and will be learning from ground up)

 

[John Nurick]

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

The following Microsoft Knowledgebase articles are helpful too:
ACC: Sending the Current Record to Word 97 with Automation (Q131583)
http://support.microsoft.com/?id=131583
Hi Doobrie,

You can control Excel from Access to create the workbook (or open one
baseed on an existing "template") and put the data into it. The
following links sholuld get you started:

Sample Excel automation
http://www.mvps.org/access/modules/mdl0006.htm

ACC2000: Using Automation to Create and Manipulate an Excel Workbook
(Q210148) http://support.microsoft.com/?id=210148

ACC: Using Automation to Create and Manipulate an Excel Workbook
(Q142476)
http://support.microsoft.com/?id=142476


There's also a white paper and code samples including tutorials
available from Microsoft at
http://support.microsoft.com/?id=253235



Also, search www.mvps.org/accessOn Sun, 23 Nov 2003 23:02:51 -0000,

 

[doobr1e]

--

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

thank you for those pointers, proves and shows how it can be done, so on
with the access learning curve now ...

cheers.