Beyond Excel: VBA and Database Manipulation:

November, 2009

1

November 30, 2009  5:02 PM

Searching for Codes

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

[caption id="attachment_307" align="alignright" width="338" caption="frmPrompt Dates and IDs"]

  Bookmark and Share     1 Comment     RSS Feed     Email a friend

November 23, 2009  10:08 PM

Creating a Date Prompt Form

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

We're going to replace XL's limited InputBox function with a user form.  If you've never created a user form, don't worry.  YouTube has several decent tutorials for you.  Check these out (at least the first one anyway), then come back here. YouTube videos on how to create forms in VBA

  Bookmark and Share     0 Comments     RSS Feed     Email a friend


November 18, 2009  9:13 PM

Good Form

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

If we stopped with only what has been posted in this blog so far, we would have a powerful tool set to create meaningful charts and drill down pivot tables from data residing in just about any database.  It only takes a couple of minutes to replace the SQL statement in Macro1() and to set...


November 10, 2009  5:58 PM

Say Goodbye to QueryTables

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

We started with the QueryTable object in order to ease into this subject.  It's time to say farewell to QueryTable and fully embrace ADO.  I'm using ADO, not because it's the best, but because it is compatible with everything my customers have and (I'm guessing) with 98% of all current XL...


November 7, 2009  10:35 PM

Using ADO to Read a Database

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

Up till now, we've used XL's QueryTable object to retrieve records from databases.  This post breaks away from the QueryTable to leverage the power of ADO.  One of the advantages of ADO is that we can create user defined functions to use directly in XL just like any normal XL function. As...


November 3, 2009  6:07 PM

Delivering a Finished Product

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

Last post I introduced the wrapper for creating PivotTables and PivotCharts.  This wrapper isolates the changes you must make to add PivotTables and PivotCharts to just one routine.  By isolating these changes, your job is simplified and setting up PivotTables and Charts can...


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: