Export Updated Data to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
TKM said:
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!
Click to expand...
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.
 
Back
Top