Trying to find an automated way to export query result (From Access) to formatted Excel Spreadsheet saved on local machine. I have tried linking and embedding-saving spreadsheet as another file. But each time the process runs, it tries to update all previous files when they are opened. This confuses users and I need to be able to keep previous results intact. Any ideas would be helpful as I am still learning!
