Re: Code to export my query as XLS to same directory each week.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "jalexander via AccessMonster.com" <u9891@uwe>
Date: Thu, 17 Jan 2008 22:50:55 GMT

Thanks for the help.
Question: How can I alter my code to always save the file to the same place?

CTomac wrote:

I have the following query: qryEquipment_Intelebill
- which I output as an Excel file

[quoted text clipped - 35 lines]

--
Message posted viahttp://www.accessmonster.com

To auto-send the email, add this after you output to excel:

DoCmd.SendObject acSendNoObject, , , "[Your Recipient]", , ,
"[Subject]" , _
"[Link here], 0

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200801/1

.

Follow-Ups:
- Re: Code to export my query as XLS to same directory each week.
  - From: CTomac

References:
- Code to export my query as XLS to same directory each week.
  - From: cw via AccessMonster.com
- Re: Code to export my query as XLS to same directory each week.
  - From: CTomac

Prev by Date: Re: Continuous Forms Formatting
Next by Date: Re: Vlookup problem
Previous by thread: Re: Code to export my query as XLS to same directory each week.
Next by thread: Re: Code to export my query as XLS to same directory each week.
Index(es):
- Date
- Thread