How can I run a MS Query on a open workbook? Is it possible?
Yes, see this kb article for anther method as well: http://vbaexpress.com/kb/getarticle.php?kb_id=88
Forum Rules