Sending Access data to Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CyndyG - 12 Sep 2005 05:29 GMT

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.

Reply to this Message

Ken Snell [MVP] - 12 Sep 2005 14:02 GMT

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

Signature

Ken Snell
<MS ACCESS MVP>

> How do I write the vba code for the following.
> My query(qryCIO) has a parameter: Enter Start Date and Enter End Date.
[quoted text clipped - 7 lines]
> ahtCommonFileOpenSave,but where does it fit with the TransferSpreadsheet
> method.

Reply to this Message