MS Query - How Can I Launch It

Discussion in 'Microsoft Excel Misc' started by Guest, May 10, 2006.

  1. Guest

    Guest Guest

    Should be simple. I just want to launch MS Query from inside Excel.

    I don't have a query I want to open in it - I just want to open it "empty",
    as it were.

    I've looked through the menus and the no-help system.

    Any bright ideas?

    Many thanks,

    Tom.
     
    Guest, May 10, 2006
    #1
    1. Advertisements

  2. Guest

    Guest Guest

    Data > GetExternalData > CreateNewQuery

    Vaya con Dios,
    Chuck, CABGx3



    "mr tom" wrote:

    > Should be simple. I just want to launch MS Query from inside Excel.
    >
    > I don't have a query I want to open in it - I just want to open it "empty",
    > as it were.
    >
    > I've looked through the menus and the no-help system.
    >
    > Any bright ideas?
    >
    > Many thanks,
    >
    > Tom.
     
    Guest, May 10, 2006
    #2
    1. Advertisements

  3. Guest

    Guest Guest

    I don't want the wizard, and I don't want to specify a database.
    Unfortunately, the options below don't exist in Excel 2002 and the
    alternatives won't take me into a bare MS Query with nothing launched.

    Any ideas?

    Many thanks,

    Tom.

    "CLR" wrote:

    > Data > GetExternalData > CreateNewQuery
    >
    > Vaya con Dios,
    > Chuck, CABGx3
    >
    >
    >
    > "mr tom" wrote:
    >
    > > Should be simple. I just want to launch MS Query from inside Excel.
    > >
    > > I don't have a query I want to open in it - I just want to open it "empty",
    > > as it were.
    > >
    > > I've looked through the menus and the no-help system.
    > >
    > > Any bright ideas?
    > >
    > > Many thanks,
    > >
    > > Tom.
     
    Guest, May 10, 2006
    #3
  4. Guest

    Guest Guest

    Check your office directory (in my case C:\program files\Microsoft
    Office\Office11) for an application called MSQRY32.EXE, and double click on
    it. This should launch an empty instance of MS Query.

    Miguel.

    "mr tom" wrote:

    > I don't want the wizard, and I don't want to specify a database.
    > Unfortunately, the options below don't exist in Excel 2002 and the
    > alternatives won't take me into a bare MS Query with nothing launched.
    >
    > Any ideas?
    >
    > Many thanks,
    >
    > Tom.
    >
    > "CLR" wrote:
    >
    > > Data > GetExternalData > CreateNewQuery
    > >
    > > Vaya con Dios,
    > > Chuck, CABGx3
    > >
    > >
    > >
    > > "mr tom" wrote:
    > >
    > > > Should be simple. I just want to launch MS Query from inside Excel.
    > > >
    > > > I don't have a query I want to open in it - I just want to open it "empty",
    > > > as it were.
    > > >
    > > > I've looked through the menus and the no-help system.
    > > >
    > > > Any bright ideas?
    > > >
    > > > Many thanks,
    > > >
    > > > Tom.
     
    Guest, May 10, 2006
    #4
  5. Guest

    Guest Guest

    Many thanks.

    I've stuck a shortcut on my desktop. That's exactly what I needed.

    Tom.

    "Miguel Zapico" wrote:

    > Check your office directory (in my case C:\program files\Microsoft
    > Office\Office11) for an application called MSQRY32.EXE, and double click on
    > it. This should launch an empty instance of MS Query.
    >
    > Miguel.
    >
    > "mr tom" wrote:
    >
    > > I don't want the wizard, and I don't want to specify a database.
    > > Unfortunately, the options below don't exist in Excel 2002 and the
    > > alternatives won't take me into a bare MS Query with nothing launched.
    > >
    > > Any ideas?
    > >
    > > Many thanks,
    > >
    > > Tom.
    > >
    > > "CLR" wrote:
    > >
    > > > Data > GetExternalData > CreateNewQuery
    > > >
    > > > Vaya con Dios,
    > > > Chuck, CABGx3
    > > >
    > > >
    > > >
    > > > "mr tom" wrote:
    > > >
    > > > > Should be simple. I just want to launch MS Query from inside Excel.
    > > > >
    > > > > I don't have a query I want to open in it - I just want to open it "empty",
    > > > > as it were.
    > > > >
    > > > > I've looked through the menus and the no-help system.
    > > > >
    > > > > Any bright ideas?
    > > > >
    > > > > Many thanks,
    > > > >
    > > > > Tom.
     
    Guest, May 10, 2006
    #5
  6. Guest

    Guest Guest

    If you do Data > GetExternalData > CreateNewQuery > Select "ExcelFiles" > OK
    > then X out of the "Select Workbook" pop-up > this should leave you in the

    MSQuery window.......

    Vaya con Dios,
    Chuck, CABGx3


    "mr tom" wrote:

    > I don't want the wizard, and I don't want to specify a database.
    > Unfortunately, the options below don't exist in Excel 2002 and the
    > alternatives won't take me into a bare MS Query with nothing launched.
    >
    > Any ideas?
    >
    > Many thanks,
    >
    > Tom.
    >
    > "CLR" wrote:
    >
    > > Data > GetExternalData > CreateNewQuery
    > >
    > > Vaya con Dios,
    > > Chuck, CABGx3
    > >
    > >
    > >
    > > "mr tom" wrote:
    > >
    > > > Should be simple. I just want to launch MS Query from inside Excel.
    > > >
    > > > I don't have a query I want to open in it - I just want to open it "empty",
    > > > as it were.
    > > >
    > > > I've looked through the menus and the no-help system.
    > > >
    > > > Any bright ideas?
    > > >
    > > > Many thanks,
    > > >
    > > > Tom.
     
    Guest, May 10, 2006
    #6
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Gru

    Weird Error Message on Launch

    Gru, Aug 2, 2003, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    276
    Orlando Magalhães Filho
    Aug 2, 2003
  2. nroberts

    Launch Excel XP opens multiple docments. . .

    nroberts, Aug 5, 2003, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    289
    Gord Dibben
    Aug 6, 2003
  3. Cedric Dennis

    Can I launch macro by a cell click ?

    Cedric Dennis, Mar 11, 2005, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    330
    Don Guillett
    Mar 11, 2005
  4. Guest
    Replies:
    0
    Views:
    373
    Guest
    Jun 30, 2005
  5. Guest

    RE: Problem with MS Query - can't edit query

    Guest, Oct 22, 2005, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    374
    Richard E
    Dec 12, 2005
  6. Guest
    Replies:
    0
    Views:
    361
    Guest
    Apr 11, 2006
  7. Replies:
    5
    Views:
    429
    Guest
    May 9, 2006
  8. Can't launch Excel

    , Jan 1, 2007, in forum: Microsoft Excel Misc
    Replies:
    3
    Views:
    333
    Chip Pearson
    Jan 2, 2007
Loading...