Output the results of a query to Excel 
February 27th, 2007, 02:25 PM
| | | |
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!
|
February 27th, 2007, 03:55 PM
| | | | re: Output the results of a query to Excel
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!
| |
February 28th, 2007, 07:55 PM
| | | | re: Output the results of a query to Excel
On Feb 27, 10:41 am, "DavidB" <j...@yahoo.comwrote: Quote:
DoCmd.TransferSpreadsheet
>
On Feb 27, 9:16 am, "Matt" <mdw233...@yahoo.comwrote:
>
>
>> Quote:
I am currently outputting the results of a query to an Excel Workbook
using the following line of code:
| > Quote: |
DoCmd.OutputTo acOutputQuery, queryName, acFormatXLS, , True
| > Quote:
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.
| > Quote: |
As always, thanks in advance for any help!- Hide quoted text -
| >
- Show quoted text -
| Thanks!!! |  |
| | |  /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 225,702 network members.
|
