Thanks PETE, and then how to open the file (using vba code)?
--- In [email protected], "Bradshaw, Peter A C301"
<[EMAIL PROTECTED]> wrote:
> If you are doing it in code, this is how you would do it:
>
> DoCmd.OutputTo acQuery, "qryQueryName", "MicrosoftExcel
(*.xls)", "", True, ""
>
> - PETE
>
> -----Original Message-----
> From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of Clauss Gilbert
> Sent: Thursday, May 12, 2005 5:31 AM
> To: '[email protected]'
> Subject: RE: [ms_access] naming excel file
>
>
> Write the query in Access, close it, right click on its
name, choose
> "export", browse, choose file type Excel. The result of the
query is
> exported and opened with Excel.
>
> Gilbert
>
> -----Message d'origine-----
> De : [email protected]
[mailto:[EMAIL PROTECTED] la
> part de programphandhoe
> Envoy� : jeudi 12 mai 2005 07:32
> � : [email protected]
> Objet : [ms_access] naming excel file
>
>
> how can i export a query to a specific excel file name,and
then open
> the excel file?
>
> thang you.
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/ms_access/
>
> * To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
>
> * Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service <http://docs.yahoo.com/info/terms/> .
>
>
>
> -------------------------------------------------------------------
-----------
> CONFIDENTIALITY NOTICE: If you have received this email in error,
please immediately notify the sender by e-mail at the address
shown. This email transmission may contain confidential
information. This information is intended only for the use of the
individual(s) or entity to whom it is intended even if addressed
incorrectly. Please delete it from your files if you are not the
intended recipient. Thank you for your compliance. Copyright 2005
CIGNA
>
=====================================================================
=========
>
>
> [Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
