I have included the file with the code and usage instructions for the database function qx in the group's files directory.
QX_enhanced_database_function.xls Note the code is not password protected - feel free to mod or canibalize as needed. Nevertheless, citing myself as a source would be the 'right thing to do' ;^) On Apr 2, 5:15 pm, Dougie Excel <douglaswilliamsm...@yahoo.com> wrote: > 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.
