Sending Access data to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You put the call to the API function as the argument for the "export to
filename" argument in the TransferSpreadsheet action.
 
Back
Top