http://www.douglaswilliamsmith.net/Excel_Functions/
Frequent use of database functions in Excel over my career prompted me to start making an enhanced ‘user defined’ function in Excel for retrieving data from Excel databases in the mid 90’s. In the meantime, functionality has been continually added to bring a query functionality comparable to that of SQL queries. The attached is the current status after 15 years of occasional development. Note: some of the functions included in the linked excel file won’t work if you open the file over the internet – it will be necessary to download the file and open it in a ‘real’ session of Excel (ie not embedded in your browser). Your virus checkers will probably flag this file as containing ‘potentially dangerous macros’. This is normal: virus checkers consider all macros to be ‘potentially dangerous’ and there is no way to make a user-defined function in excel without VBA code (interpreted by most virus checkers as ‘macro code’). I don’t know of any conditions that qx would cause an Excel session to ‘hang’ but it’s probably a good idea to test the file in its own session of Excel (ie without any files of your own open in the same sessions or at least none containing unsaved changes). After you are sure it runs in a stable manner on your system, then feel free to migrate the VBA code into your own Excel installation and use as needed. = Doug -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using "remove me" as the subject.
