Beyond Excel: VBA and Database Manipulation:

August, 2010

1

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

August 21, 2010  7:47 PM

Controlling the Cursor



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

Updating databases demands discipline.  Excel is about freedom.  It's what your users love about it.  Even so, updating databases demands discipline and striking the right balance between freedom and discipline is key to making Excel a great tool for users and DBAs. We've just invested most...


August 9, 2010  8:13 PM

Check Entry – Worksheet_Change – Code



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

Last post we discussed the theory behind the WorkSheet_Change event code below.  This code must be in the WorkSheet class as it only responds to events for the worksheet that contains it.  Here is the code: 

  Bookmark and Share     0 Comments     RSS Feed     Email a friend


August 6, 2010  5:21 PM

Check Entry – Worksheet_Change – Theory



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

There are two times when you want to check entries:
  1. When the user changes something and 
  2. When they want to post entries to the database (aka add, change or delete data). 


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: