I need to export a query daily to Excel and have it save in a specific location. I have reviewed multiple threads that are similar to this, but none that really get me what I need. I have seen that you might be able to do this via VBA code, but don’t know how to write that.
My query name is “qryDRPJobTracking”.
Can this be exported daily without me having to click on anything each day?