Re: MS Query: change startup to NOT connect.

[Dick Kusleika]

On Sat, 28 Mar 2009 13:07:01 -0700, RickH <ric...@tirnanog.com(do not
spam)> wrote:

>I have several hundred spreadsheets in which I need to edit the query.
>It would be much easier if MS Query would simply let me edit the query,
>rather than trying to open the data source 1st, which I have no access to,
>since my client's network is not accessible.
>Right now, I save as XML, edit the strings with notepad, open again in
>Excel, save as XLS.
>Really painful and error prone.
>I just need to change the default startup behavior of MS Query to NOT connect.

Rick: I don't think it's possible. One option is to download QueryManager

http://www.jkp-ads.com/download.asp

You still have the possibility of typing errors, but you can eliminate all
that saving.
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com