Export Updated Data to Excel

[Guest]

I know how to ouput and export a report to Excel. But what do I do or where
do I begin so when a user clicks a button. It will export the CURRENT DATA to
a workbook in Excel? Do I use a button on a form and use the ouput or? Please
help!

 

[Phil Smith]

I know how to ouput and export a report to Excel. But what do I do or where
do I begin so when a user clicks a button. It will export the CURRENT DATA to
a workbook in Excel? Do I use a button on a form and use the ouput or? Please
help!

Use a Button on a form, which which will run a macro that uses the
"output to" macro command to copy it into an Sxcell spreadsheet. You
can even set the "autostart" to yesm which will automatically open Excel
to that spreadsheet if you wish.