Run Query and Export to Spreadsheet

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

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,

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
 
Back
Top