February 27th, 2007, 02:25 PM
| | |  Output the results of a query to Excel
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!!! |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is Off | | |
| | | What is Bytes?
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 network members.
|
