Access 2007 - Default export location

[Tony]

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.

 

[Áííá]

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.

 

[Gina Whipp]

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

 

[John W. Vinson]

Gina Whipp
2010 Microsoft MVP (Access)

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

 

[Gina Whipp]

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

 

[Tony Toews [MVP]]

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/

 

[Duane Hookom]

Awesome Gina! Well deserved!

 

[Gina Whipp]

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