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

Browse Site by Tags

Showing related tags and posts accross the entire 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

  • Passing a list from Excel to MS Query

    I've tried this several ways, but no success so far. Is it possible to pass multiple values from an Excel cell as parameters in a Data query? In MS Query, this looks like "IN (1,2,3,4,5)". Or, calling a parameter looks like "[List]" which can be tied to one worksheet cell. However...
    Posted to Data Exchange (Forum) by Omar on Sat, Jan 26 2008

  • Welcome to the data exchange forum

    Welcome to the Excel Data Exchange Forum You should post any questions on getting data in and out of Excel here. You can use just about any technology to do this, XML, ODBC, OLEDB, Web, etc. Have fun
    Posted to Data Exchange (Forum) by Nick Hodge on Sat, Jan 5 2008
Page 1 of 1 (3 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.