How To Create a Microsoft Access Macro (with a query data) to Export Information to Excel (1 Viewer)

[Shankar14]

I am trying to write a macro (command button) in a way that, when I click the command button, underlying data from a query is to be saved in excel form in the "on click" section. Can some one guide me on how to do this ?

 

[CJ_London]

Google ‘vba transferspreadsheet’ for one method

if you need a more detailed response you will need to provide more detail such as the name of your query/form/subform, whether filters have been applied to the form, whether the save is to replace an existing spreadsheet or create a new one etc

 

[arnelgp]

you can Create a "form" for you 2 date parameters.
see this demo.