DoCmd.TransferSpreadsheet
On Feb 27, 9:16 am, "Matt" <mdw233...@yahoo.comwrote:
Quote:
Hi All,
>
I am currently outputting the results of a query to an Excel Workbook
using the following line of code:
>
DoCmd.OutputTo acOutputQuery, queryName, acFormatXLS, , True
>
What this is doing is asking the user where to specify where the file
will be saved and then opens the file. What I would like to do is to
just open a new workbook without asking the user to specify the file
save. It would be like opening excel and pasting the results of the
query in ... if the user wants to save they can later.
>
As always, thanks in advance for any help!
