Correct format for Docmd.Transferspreadsheet 1

[WeeDram]

I've created the following function, but it is falling over at the Docmd.TransferSpreadsheet line - I'm just not sure how to include the recordset in the command.
Can someone advise where I'm going wrong?

Code:

Function fcast_output()

Dim db As Database
Dim rs As Recordset

Set db = CurrentDb

Set rs = db.OpenRecordset("Select * from Forecast_Template Where Forecast_Template.country_description = 'UK';")

DoCmd.TransferSpreadsheet acExport, 8, rs, "G:\MyFolder\Forecast_Template_Test", False, "Data"

End Function

Thanks

Peter

 

[PHV]

You can't export a RecordSet but a Query ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[WeeDram]

PHV - Many thanks, means I'll need to create a few queries to do what I want!

Peter