ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   microsoft query in excel default save path (https://www.excelbanter.com/excel-discussion-misc-queries/124387-microsoft-query-excel-default-save-path.html)

George Applegate

microsoft query in excel default save path
 
If I open a microsoft query to get external data in excel, it opens
query (I am NOT using the query wizard). Once I define the query, I
save it so it can be used again.

QUESTION!!!

WHERE can I change the default path: It is right now under something
like: My Documents\documents and settings\username.domain\application
data\microsoft\queries.

I want to change this to DEFAULT to K:\queries.

Is there a way to do this??

thanks,
ga
George Applegate



All times are GMT +1. The time now is 11:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com