I have a database that currently when you click the button on the form, it opens the report "rpt_Test".
I have to then manually view it with excel and save it.
I'm looking for a code that will do the following:
1) Click the button on form = msgbox ("View report or export?") vbyesno
2) Yes = View report
2a) No = Export into S:\Testing\TestReport.xls
2b) msgbox ("Successfully exported!")
3) exit report view and just show form
I tried looking through the macro commands and couldn't find anything, so i'm ok using VBA instead
Thanks for all the help!
Bookmarks