Change default export to Excel location - Access 2007
in [General]
|
From: Tony on 9 Apr 2010 15:55 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.
From: Gina Whipp on 9 Apr 2010 22:40 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 "Tony" <|toxendine(a)hoopercorp.com|> wrote in message news:#LrTl6B2KHA.5680(a)TK2MSFTNGP02.phx.gbl... 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.
From: Tony on 12 Apr 2010 11:01 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... "Gina Whipp" <NotInterested(a)InViruses.com> wrote in message news:852109A0-4778-4572-8C70-0175A673C6F9(a)microsoft.com... > 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 > > "Tony" <|toxendine(a)hoopercorp.com|> wrote in message > news:#LrTl6B2KHA.5680(a)TK2MSFTNGP02.phx.gbl... > 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. >
From: Gina Whipp on 12 Apr 2010 22:00 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 "Tony" <|toxendine(a)hoopercorp.com|> wrote in message news:eNLQZEl2KHA.5480(a)TK2MSFTNGP05.phx.gbl... 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... "Gina Whipp" <NotInterested(a)InViruses.com> wrote in message news:852109A0-4778-4572-8C70-0175A673C6F9(a)microsoft.com... > 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 > > "Tony" <|toxendine(a)hoopercorp.com|> wrote in message > news:#LrTl6B2KHA.5680(a)TK2MSFTNGP02.phx.gbl... > 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. >
From: Tony on 15 Apr 2010 09:45
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 "Gina Whipp" <NotInterested(a)InViruses.com> wrote in message news:F578595A-216D-4821-B600-A2C19236CBFB(a)microsoft.com... > 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 > > "Tony" <|toxendine(a)hoopercorp.com|> wrote in message > news:eNLQZEl2KHA.5480(a)TK2MSFTNGP05.phx.gbl... > 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... > > > "Gina Whipp" <NotInterested(a)InViruses.com> wrote in message > news:852109A0-4778-4572-8C70-0175A673C6F9(a)microsoft.com... >> 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 >> >> "Tony" <|toxendine(a)hoopercorp.com|> wrote in message >> news:#LrTl6B2KHA.5680(a)TK2MSFTNGP02.phx.gbl... >> 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. >> > |