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 ?
How To Create a Microsoft Access Macro (with a query data) to Export Information to Excel
- Thread starter Shankar14
- Start date
- Local time
- Today, 06:40
- Joined
- Feb 19, 2013
- Messages
- 17,087
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
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
