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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Link or Import Data from Excel to Access 2
Alternative to TransferSpreadsheet 2
How to get a FORMULA into Excel 3
Possible to import a specific sheets data from excel into access? 1
How do you Export Data from Access into Multiple Tabs in Excel from one query 8
Exported Excel File is Incomplete 14
export to excel and format excel rows? 5

Back
Top