Change default export to Excel location - Access 2007
in [General]
|
From: Gina Whipp on 17 Apr 2010 02:55 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 "Tony" <|toxendine(a)hoopercorp.com|> wrote in message news:OttHfHK3KHA.3580(a)TK2MSFTNGP05.phx.gbl... 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. >> > |