I am exporting data to Excel from a Macro I created in Access. Everytime I export the report, query, or table it rewrites the file or basically replaces it. For example the macro in Access is set to export to the Excel file called “TEST.xls” The problem is that I constantly import new raw data and run it through my macro in accessand then when it comes time to export it to excel through the Macro is just replaces the file.
The problem with it replacing the file is that I need to make formatting changes, to the excel file after it is exported so everytime I have to make these changes because they are constantly deleted. Is there a way to created an excel file template with a certain format (borders, shading, size of cells) that my macro in access could constantly export to and not have it replace the file with a new one? I basically want to set up an excel file with a certain format and contantly export and replace data in it and have it in the format I specified. I have not found a way to keep my excel file from being replaced when I do this or write to an existing excel file while preventing formatting changes or data from being deletd after I export my data from access into it.
The problem with it replacing the file is that I need to make formatting changes, to the excel file after it is exported so everytime I have to make these changes because they are constantly deleted. Is there a way to created an excel file template with a certain format (borders, shading, size of cells) that my macro in access could constantly export to and not have it replace the file with a new one? I basically want to set up an excel file with a certain format and contantly export and replace data in it and have it in the format I specified. I have not found a way to keep my excel file from being replaced when I do this or write to an existing excel file while preventing formatting changes or data from being deletd after I export my data from access into it.