Beyond Excel: VBA and Database Manipulation:

odbc


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


September 14, 2010  8:02 PM

Controlling the Cursor: Position_Curosr_In_Data



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

The last few posts covered Worksheet_Change and Worksheet_SelectionChange events.  Both rely on a function called Position_Cursor_In_DataPosition_Cursor_In_Data's Job is...


September 8, 2010  5:49 PM

Back to Controlling the Cursor



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

This post returns to controlling the cursor in update spreadsheets. As the user positions the cursor on the spreadsheet, we want to have it jump over 'locked' cells to the next 'unlocked' cell.  The words 'locked' and 'unlocked' are quoted because we aren't exactly using Excel's notion of...


August 31, 2010  10:16 AM

Strategies for Speeding Spreadsheets



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

By guest contributor: Yoav Ezer

NOTE: This post provides an example spreadsheet: accelerating-excel.xlsm.  Due to concern for your system's security, macro enabled...


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: