Sending Access data to Excel

C

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.
 
K

Ken Snell [MVP]

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