Export to Excel (Using Runtime)

[AJordan]

I have a packaged database that runs smoothly on the network. However I would like to be able to have the option to export certain queries to excel for "one time" analysis from time to time. The computers this program is installed on do not have MS Access and thus are running Runtime. How can I add the export feature so that runtime users can export to Excel?

 

[boblarson]

You can use a command button to start the code that exports and you can, if you want, use my code here which will send any table or query to Excel. You simply put this code into a standard module (not a form or report module) and then call it by:

SendTQ2Excel "QueryOrTableNameHere"

 

[AJordan]

Thanks Bob, your a great help! I think I even bought a book based on your amazon review awhile ago!

 

[boblarson]

Glad we could help.