Export table data from access to excel with a command button

[rplohocky]

I've searched the net completely looking for a way to export my table data into a preexisting excel workbook without success. I would like to have a command button on a form that when clicked, will copy a table of data in to a "pre-named existing" workbook and a specific worksheet.

Any help would be great, thanks.

 

[welshgasman]

Does this help?

Access VBA DoCmd.TransferSpreadSheet Method

 

[rplohocky]

Does this help?

Access VBA DoCmd.TransferSpreadSheet Method

Thanks but not really. I am brand new at Access and don't know exactly where and how to insert the code into VBA. I have written many macros in excel but only a couple in Access. Also the code they are showing does not have an option to select a specific page to place the data. Currently I have a macro that will export the data into a blank workbook and name the sheet but I am wanting to have different buttons create different exports of data. Such as one tab would be for "completed" and another tab would be "not completed". I built the macro using the macro function in Access.

 

[alansidman]

In Welschgasman's link, this is the code you should be using as an example.

Public Sub xportQuery()
    DoCmd.TransferSpreadsheet TransferType:=acExport, SpreadsheetType:=acSpreadsheetTypeExcel9, TableName:="Query1", FileName:="C:\test\template.xlsx", Range:="exportRange"
End Sub

 

[welshgasman]

How you implement it is up to you.
The most basic would be the Click event of a button as you mentioned.
Change the names in the code to match.

alansdman has pointed out what code on that page you need.
If you read the page, it will explain the parameters as well.