Transfer 2 querys to the excel workbook but to different sheets

's Computer Specifications

Hi

I have a problem. I use the following code to transfer a query to an excel
sheet.

Private Sub Command9_Click()
DoCmd.OutputTo acOutputQuery, "6_FORECAST_TO_VENDOR", acFormatXLS,
"Forecast.XLS", True
End Sub

What I want is to transfer yet another query to the same excel workbook but
another sheet. How can this be done?

regards
Ticoton

's Computer Specifications

Hi,
have a look here:
http://accessblog.net/2006/07/export...cel-range.html

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

"Ticotion" <(E-Mail Removed)> wrote in message
news:16E74D61-1831-41B6-9D78-(E-Mail Removed)...
> Hi
>
> I have a problem. I use the following code to transfer a query to an excel
> sheet.
>
> Private Sub Command9_Click()
> DoCmd.OutputTo acOutputQuery, "6_FORECAST_TO_VENDOR", acFormatXLS,
> "Forecast.XLS", True
> End Sub
>
> What I want is to transfer yet another query to the same excel workbook
> but
> another sheet. How can this be done?
>
> regards
> Ticoton

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Merging workbooks into different sheets in a different workbook	=?Utf-8?B?Tmljbw==?=	Microsoft Excel Misc	0	6th Nov 2007 08:49 AM
Querys based on Querys	=?Utf-8?B?R2lsbA==?=	Microsoft Access Queries	7	2nd Sep 2007 07:27 PM
Print sheets by "All Sheets in workbook, EXCEPT for specific named sheets". Possible?	Corey	Microsoft Excel Programming	2	11th Dec 2006 02:35 AM
querys from multiple sheets	tlachena	Microsoft Excel Misc	2	27th Nov 2005 05:57 PM
passing different id for open querys for code	Rick Brandt	Microsoft Access Forms	5	4th May 2005 04:15 AM