Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
All Tags » External Data » MSQuery (RSS)

Browse Forum Posts by Tags

Showing related tags and posts for the Forums application. See all tags in the site

  • Re: Display the Edit Query Dialog

    Hi Sam, Yes, that sounds like a lot of effort. Lifting a finger and all... You could code something that retrieves data from the other workbook without using the query editor. Basically an Open-Copy-Paste-Close action would do the trick. A userform could be used to create some flexibility for parameter...
    Posted to Data Exchange (Forum) by Rembo on Wed, May 21 2008

  • Re: Display the Edit Query Dialog

    Hi Sam, You could store the query (.dqy file) and use the following: Sub StartQry() Call Shell("Drive:\PathTo\msqry32.exe Drive:\PathToQry\YourQuery.dqy", 1) End Sub Haven't tested it under Windows Vista though. Rembo
    Posted to Data Exchange (Forum) by Rembo on Tue, May 20 2008
Page 1 of 1 (2 items)
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.