Run Query and Export to Spreadsheet

[ChuckW]

Hi,

I want to run a query and download the results into a
spreadsheet. I am building a forms application and want
create a command button that a specific user would
click. The spreasheet would simply download to the
person's PC. I was looking at Macros but couldn't figure
out how to do this. I could find the Transfer to
Spreadsheet command but could not find the macro command
for running a query.

Thanks,

Chuck

 

[Glenn]

Macro Command for running a query is: OpenQuery

 

[ChuckW]

Glenn,

Thanks for your response. I created this macro which
will run a query and download the query results to Excel.
I noticed though I need to delete the Excel Worksheet
each time before I do this or it will not write over it.
Is there a way for it to either delete the Excel file and
write over it?

Thanks,

Chuck