Change default export to Excel location - Access 2007

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hi,

Does anyone know how I might be able to change the default location for
exporting tables, queries, etc. from Access to Excel? It defaults to My
Documents, which I can't stand because it forces me to drill down to find
the spreadsheet. I'd rather that I could set it to go to my desktop. I've
looked in the Access settings and registry, but could not find where to make
the change.

Any help is appreciated.
 
Tony,

Look at the TransferSpreadsheet method (in Help)... using that you can put
any path you wish.

--
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

Hi,

Does anyone know how I might be able to change the default location for
exporting tables, queries, etc. from Access to Excel? It defaults to My
Documents, which I can't stand because it forces me to drill down to find
the spreadsheet. I'd rather that I could set it to go to my desktop. I've
looked in the Access settings and registry, but could not find where to make
the change.

Any help is appreciated.
 
Gina,

Thanks for the suggestion, but I'm looking for something a lot more down &
dirty - select the records, click export, and be done with it. I'm assuming
there must be a reg key I can hack; I can't find anything in the UI...
 
Tony,

Not that I am aware of... Most folks would just attach some code or use the
TransferSpreadsheet on a button.

Good Luck!
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

Gina,

Thanks for the suggestion, but I'm looking for something a lot more down &
dirty - select the records, click export, and be done with it. I'm assuming
there must be a reg key I can hack; I can't find anything in the UI...
 
Thanks, Gina. If you've got any 'pull' in Redmond, perhaps this could be a
suggestion for the dev team. Something like default file location.

I appreciate the feedback.

Tony
 
Tony,

Nope no *pull* but will yell from the mountain tops!

--
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

Thanks, Gina. If you've got any 'pull' in Redmond, perhaps this could be a
suggestion for the dev team. Something like default file location.

I appreciate the feedback.

Tony
 
Back
Top