Forum Discussion
GeorgieAnne
Mar 26, 2025Iron Contributor
How to make a Saved Export
Hello All, My very first post in the MS-Access lounge. I need to automate these steps: Press F-11 to get to the All Access Objects pane. Select a Table named Priority The Priority table has a D...
XPS35
Mar 26, 2025Iron Contributor
Why no VBA? You can do that in VBA with a single line of code. Something like
DoCmd.TransferSpreadsheet acExport,, "SELECT *FROM Priority WHERE Your Date = Date()", "YourExcel.xlsx"