I have an Access database running on a Citrix server that allows users to successfully export query results to Microsoft Excel. I use the following line in a module:
DoCmd.OutputTo acQuery, "CourseOpty", "MicrosoftExcel(*.xls)", "", True, ""
The problem is my users do not want to save the file before they see the results in Excel, and that is what they are required to do as it is coded. I'm just not sure what I need to adjust/insert to simply allow the users to view their query results in Excel and then decide where they want to save the results.
Something tells me this is a simple adjustment, but my frustration is not allowing me to see the solution. Many thanks, in advance, for assistance with this.
DoCmd.OutputTo acQuery, "CourseOpty", "MicrosoftExcel(*.xls)", "", True, ""
The problem is my users do not want to save the file before they see the results in Excel, and that is what they are required to do as it is coded. I'm just not sure what I need to adjust/insert to simply allow the users to view their query results in Excel and then decide where they want to save the results.
Something tells me this is a simple adjustment, but my frustration is not allowing me to see the solution. Many thanks, in advance, for assistance with this.