Analysing with Excel

[Jane Collins]

I have a macro button that runs a query. When the data is show when the query is open, I then want to have a button that you click on to transfer or analyse with Excel. Although I can click on the anyalyse Excel on the tool bar I would like to have this on my form as a macro for other users.

 

[Norie]

Jane

Take a look at the TransferSpreadsheet action for macros.