I would like to know if there is a way to make a button on a form to allow you to export a table to excel. I want a user to every month hit this button and send it to a default folder so that we can use this file in other ways. Thanks

Look up the TransferSpreadsheet Action.

Thank You that worked and now I think I have a hold so far on this macro world.