Beyond Excel: VBA and Database Manipulation:

excel


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

May 28, 2013  1:23 PM

SQL, UDFs, and *DTAARA (Data Areas)



Posted by: Craig Hatmaker
excel

Getting data from IBM's iSeries into XL is normally no different than other platforms.  There are exceptions.  The iSeries' multi-member files, such as source files, are problematic for SQL.  So are data areas.  This post deals with simple Data Areas. To read simple Data Areas from SQL we...


April 18, 2011  11:47 AM

“Can there be Dynamic Ranges for VLOOKUP and Data Validation List for an Invoice?”.



Posted by: Craig Hatmaker
excel

This question was posed and answered by "Mr. Excel" and "Excel is Fun" in a recent YouTube post by the same title.  Their solutions work well.  I'm going to answer with what I believe is a better approach.  It uses Tables. Tables have...


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...


January 27, 2011  9:50 AM

Animating Your Company’s Logo in Excel



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

This post shows how to animate a logo in Excel using VBA.  (Click here to download code)

Preview:
  Bookmark and Share     2 Comments     RSS Feed     Email a friend


January 18, 2011  5:28 PM

Debug Your Data with Conditional Formatting



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

(By Guest blogger Yoav Ezer) Many times when a workbook is crammed full of numbers, your data can be difficult to read. This is bad enough when you are sure the data is correct, but If you are supplied a spreadsheet that contains potential errors you really want to be able to detect them so they...


January 13, 2011  2:00 PM

Dynamic Named Ranges in Excel – Overcoming Shortcomings



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

A couple of months ago, Guest blogger Yoav Ezer posted a piece including the concept of Dynamic Named Ranges (see Strategies for Speeding Spreadsheets).  Dynamic Named Ranges...


October 4, 2010  12:58 PM

Chart Drill Down



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

PivotChart Drill DownThis seems so basic to me that I was not surprised Googling "Drilldown Excel Chart" shows lots of interest out there.  But the implementation is so simple that I was very surprised Googling "Drill Down Excel Chart"...


September 23, 2010  7:45 PM

Controlling the Cursor: Find_Unlocked_Cell



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

Today's little routine was repeated all throughout Position_Cursor_In_Data (See previous post).  It's a simple little routine with not much to talk about except one little trick:

v = Intersect(ActiveWindow.VisibleRange, Selection)
If you...


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: