I am trying to export an access report to excel. I can currently export the data and save it by hard coding the file location. I want to prompt the user for the location where they want to store it. I am not sure how to do this in Access 2000. From what I do understand is the built in FileDialog do not work in 2000?