Beyond Excel: VBA and Database Manipulation:

Tables

1

August 30, 2013  7:17 AM

Want a Free Gantt Chart App?



Posted by: Craig Hatmaker
development, excel, ListObjects, Microsoft Excel, Tables, tutorial, vba

Introducing a new approach to Gantt Charts in XL - BabyGantt.xls

BabyGantt.xls

April 7, 2011  3:41 PM

Getting User Names from Outlook Into Excel



Posted by: Craig Hatmaker
database, development, dynamic ranges, excel, ListObjects, Microsoft Excel, ms query, odbc, Outlook, sql, Tables, tutorial, vba

The company president's mother died.   The staff wanted to express their sympathy.  Cards were purchased and now we needed to make sure everyone got a chance to sign them.  We needed names on a check...


February 24, 2011  6:53 PM

Solving Dynamic Ranges with Tables/ListObjects



Posted by: Craig Hatmaker
database, development, dynamic ranges, excel, ListObjects, Microsoft Excel, ms query, odbc, sql, Tables, tutorial, vba

Dynamic named ranges have been a subject of interest on Excel boards for sometime.  Lots of people want to know what's the best way to create a named range that expands (or shrinks) according to the data entered, and can be used in formulas like VLOOKUP without change.  For some background...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: