VBA doCmd.TransferSpreadSheet

[Dav]

Hi Im trying to use VBA's doCmd.TransferSpreadSheet command to export the results of an access query to excel. My problem is that my query takes a paramater and access asks me for its value with a popup box each time I want to do the export. Is there a way to set the value of paramater before I do the TSS so that access doesnt ask me for it?

my query looks like:

"Select * from Companies Where id=[x]"

thanks