Dim Xls as excel.application
Dim BK as Excel.workbook
Dim ST as Excel.worksheet
Dim DB as DAO.database
Dim RS as DAO.recordset
set DB=currentDB
set RS=DB.openrecordset("なんちゃら")
Set Xls = CreateObject("Excel.Application")
set BK=Xls.Workbooks.Open FileName:="フルパス\エクセル名.xls"
set ST=BK.Worksheets("なんちゃら")
Xls.Visible = True
with ST
rs.movefirst
do until rs.eof
let .cells(??, ??)=rs.fields("なんちゃら")
let .cells(??, ??)=rs.fields("かんちゃら")
let .cells(??, ??)=rs.fields("ふんちゃら")
rs.movenext
loop
end with
rs.close
set rs=nothing
db.close
set db=nothing
set ST =nothing
BK.saveas filename:="フルパス\ファイル名.xls"
BK.close
set BK=nothing
Xls.close
set Xls=nothing