Sending Access data to Excel

[CyndyG]

How do I write the vba code for the following.
My query(qryCIO) has a parameter: Enter Start Date and Enter End Date.
After the dates are entered by the user I would like to export the the data
to Excel using the TransferSpreadsheet method,but need the saveas dialog box
to prompt the user.

I used the link from this group to find the API function call of
ahtCommonFileOpenSave,but where does it fit with the TransferSpreadsheet
method.

 

[Ken Snell [MVP]]

You put the call to the API function as the argument for the "export to
filename" argument in the TransferSpreadsheet action.