Yes. See the VBA help for the TransferSpreadsheet method. You can
specify Excel ranges in the method's operands.

                 John W. Vinson[MVP]    

Hi I have always found it is easier to create a csv file
on the desktop use the following -

Add this code to the button or trigger you want.  For it
to work you have to make a query called querynamehere or
rename to whatever you like.

hope that helps

Charles

Dim path As String
Dim wShell As Object
Dim strSql As String

Set wShell = CreateObject("WScript.Shell")
path = wShell.SpecialFolders("Desktop")
path2 = CurrentProject.path

Set wShell = Nothing

DoCmd.TransferText acExportDelim, , "qrynamehere", path
+ "\export" & Format(Now(), "ddmmyyyy") & ".csv", True

MsgBox ("You will now find a file on the desktop if you
left the code as you found it in the above.  If add a 2
to the end of the word "path" the file will be placed in
the databases root directory"), vbInformation, "Msgbox
title here"