export data by VBA

[Andrew]

Hi,
I wish call a sequence of routines that update my tables and export them to
an excel file(c:\report\employee.xls)

So I built this:
function callagain()
call xx
cal xx1
call xx2
end function

what's the phrase to export the tables to excel?

thank u for answer.

 

[NevilleT]

Hi

You need to use a line like

DoCmd.TransferSpreadsheet acExport, , strQueryName, strDocName

First set up a query to extract the data and put it in strQueryName

Dim strQueryName as String
strQueryName = "qryWhateverIwantToNameThe Query"

Then provide a location in strDocName

Dim strDocName as String
strDocName = "C:\My Documents\My Export\Download.xls"

 

[Douglas J. Steele]

Take a look at the TransferSpreadsheet method in the Help file.

 

[Andrew]

thanks a lot!!! I got it!!!
--
BBB

Hi

You need to use a line like

DoCmd.TransferSpreadsheet acExport, , strQueryName, strDocName

First set up a query to extract the data and put it in strQueryName

Dim strQueryName as String
strQueryName = "qryWhateverIwantToNameThe Query"

Then provide a location in strDocName

Dim strDocName as String
strDocName = "C:\My Documents\My Export\Download.xls"