David Emerson
davide at dalyn.co.nz
Thu Apr 3 18:15:57 CST 2003
I am able to use the following line to export the result of a sproc to excel - DoCmd.OutputTo acOutputStoredProcedure, "spBookingExport", acFormatXLS, strFullName However, can I do it if the sproc has parameters and I don't want the user to have to enter in the values as they are already on the form that calls the sproc? Regards David Emerson DALYN Software Ltd 25b Cunliffe St, Johnsonville Wellington, New Zealand Ph/Fax (877) 456-1205