November 23, 2009 10:08 PM
Posted by: Craig Hatmaker
database,
development,
excel,
Microsoft Excel,
ms query,
odbc,
sql,
vbaWe'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
November 18, 2009 9:13 PM
Posted by: Craig Hatmaker
database,
development,
excel,
Microsoft Excel,
ms query,
odbc,
sql,
vbaIf 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
Posted by: Craig Hatmaker
database,
development,
excel,
Microsoft Excel,
ms query,
odbc,
sql,
vbaWe 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
Posted by: Craig Hatmaker
database,
development,
excel,
Microsoft Excel,
ms query,
odbc,
sql,
vbaUp 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
Posted by: Craig Hatmaker
database,
development,
excel,
Microsoft Excel,
ms query,
odbc,
sql,
vbaLast 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...
