Does anyone know if there is a way for me to change the default export
location within Access 2007? I export a lot of data to Excel and Access
always points to My Documents. I know I can specify that I want the
workbook to open automatically, but sometimes I just want to export (fire &
forget).

Any help is appreciated.

Ï "Tony" <|(E-Mail Removed)|> Ýãñáøå óôï ìÞíõìá
news:%235$(E-Mail Removed)...
> Does anyone know if there is a way for me to change the default export
> location within Access 2007? I export a lot of data to Excel and Access
> always points to My Documents. I know I can specify that I want the
> workbook to open automatically, but sometimes I just want to export (fire
> & forget).
>
> Any help is appreciated.
>

Tony,

Have a look at the TransferSpreadsheet function. With it you can specify
where you want your file exported to.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Tony" <|(E-Mail Removed)|> wrote in message
news:%235$(E-Mail Removed)...
> Does anyone know if there is a way for me to change the default export
> location within Access 2007? I export a lot of data to Excel and Access
> always points to My Documents. I know I can specify that I want the
> workbook to open automatically, but sometimes I just want to export (fire
> & forget).
>
> Any help is appreciated.
>

On Sat, 2 Jan 2010 10:54:17 -0500, "Gina Whipp" <(E-Mail Removed)>
wrote:

>Gina Whipp
>2010 Microsoft MVP (Access)

It's great to see this .sig, Gina.

--

John W. Vinson [MVP]

Thanks!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"John W. Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
news:(E-Mail Removed)...
> On Sat, 2 Jan 2010 10:54:17 -0500, "Gina Whipp"
> <(E-Mail Removed)>
> wrote:
>
>>Gina Whipp
>>2010 Microsoft MVP (Access)
>
> It's great to see this .sig, Gina.
>
> --
>
> John W. Vinson [MVP]

John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com> wrote:

>>Gina Whipp
>>2010 Microsoft MVP (Access)
>
>It's great to see this .sig, Gina.

Very nice indeed!

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

Awesome Gina! Well deserved!

--
Duane Hookom
Microsoft Access MVP


"John W. Vinson" wrote:

> On Sat, 2 Jan 2010 10:54:17 -0500, "Gina Whipp" <(E-Mail Removed)>
> wrote:
>
> >Gina Whipp
> >2010 Microsoft MVP (Access)
>
> It's great to see this .sig, Gina.
>
> --
>
> John W. Vinson [MVP]
> .
>

Thanks Guys!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Duane Hookom" <duanehookom@NO_SPAMhotmail.com> wrote in message
news:AEB1639B-F60D-452D-8DB7-(E-Mail Removed)...
> Awesome Gina! Well deserved!
>
> --
> Duane Hookom
> Microsoft Access MVP
>
>
> "John W. Vinson" wrote:
>
>> On Sat, 2 Jan 2010 10:54:17 -0500, "Gina Whipp"
>> <(E-Mail Removed)>
>> wrote:
>>
>> >Gina Whipp
>> >2010 Microsoft MVP (Access)
>>
>> It's great to see this .sig, Gina.
>>
>> --
>>
>> John W. Vinson [MVP]
>> .
>>