VBA code to Launch and then Export data to a specified Excel worksheet

[Jameo]

Hi all,

I've been searching around the net looking for some code to help me do the following.

I have a command button that runs a series of queries. At the end of the code for the button I would like to add a section that takes the data from the final query, launches excel, and then exports it into a specified sheet. The export must clear and overwrite any existing cell values in the specified sheet, but must not remove the dynamically defined ranges for the various columns that I have already added.

Any help would be great, thanks all

 

[rohitbaby]

Paste the code and will take up from there

 

[Jameo]

Thanks mate, here is the code for my command button

Private Sub btnquery_Click()
DoCmd.SetWarnings False
On Error GoTo Err_btnquery_Click
    Dim stDocName As String
    stDocName = "CTSelectedData"
    DoCmd.OpenQuery stDocName, acNormal, acEdit
    
    stDocName = "SelectedData_Crosstab"
    DoCmd.OpenQuery stDocName, acNormal, acEdit
    
    
Exit_btnquery_Click:
    Exit Sub
Err_btnquery_Click:
    MsgBox Err.Description
    Resume Exit_btnquery_Click
DoCmd.SetWarnings True
    
End Sub