Is it possible to export data to an access database upon opening an excel file. (what I mean: Instead of getting into the file and going through the prompts to export it, can I write some code via vba to have it export to the same access database everytime once the file is clicked to open?) At my business we have the same reoccuring report and Im looking for less clicks as possible. If my users can simply click on the particular file they want, the code will do the work for them in exporting the information. Leaves a lot less room for error. THANKS!!