In my life-changing post, Running a SQL-Stored Procedure from Excel, I showed you how to make Excel interact with a SQL server Stored Procedure.
.
Since that post, I’ve had several requests to cover the topic of passing dynamic parameters to a Stored Procedure. So today, I will FINALLY show you.
» More: Running a SQL Stored Procedure from Excel with Dynamic Parameters
» More: How to Compress xlsx Files to the Smallest Possible Size
I was puttering around in Excel the other day when I noticed that the Name Box doesn’t ever show you the complete range you’ve selected.
.
For example, if I select Range A1:E8, it only shows the active cell (A1). I think it would be helpful to see some basic information on the selected range.
» More: Status Bar Fun – Show Cell Selection Info
How many times have you built a PowerPoint presentation with Excel data. We’ve all done it at some point – some of us do it on a weekly basis. The typical scenario is the weekly or monthly management review. You copy or link Excel tables and charts to a PowerPoint deck, and then refresh when it’s time to produce another exciting version of “Make the Data Look Good”.
.
In this post, I’d like to show you a technique that takes the concept of using Excel data in PowerPoint to the extreme. The basic idea is that you can build a workbook in such a way that it mimics a PowerPoint presentation. That is, the workbook is the presentation itself and each worksheet becomes a slide in the presentation.
.
Once you do that, you can easily convert that workbook into an actual PowerPoint presentation using a bit of VBA automation.
.
I’ve created a sample workbook so you can get an idea of how this works.
Download the Workbook
When developing your Excel or Access application, it’s not uncommon to need to capture your user’s domain/username for one reason or another. A user’s domain/username combination is the traditional unique identifier for a user - often captured by programmers to do things in like:
.
There are literally half a dozen ways to capture a user’s domain name and user name. In this post, I’ll give you a very easy method using the Environ function.
A few days ago, Kusleika posted an article that showed how to code a Dynamic Matrix in Excel. He later came back with code to achieve a matrix using ADO.
.
This inspired me to consider applying a Jet Crosstab query to an Excel Table.
» More: Running Crosstab Queries in Excel
Besides being an Excel and Access guru, I moonlight as an Xcelsius expert. Because Xcelsius is so closely tied to Excel, I’ve always seen Xcelsius as an extension of the Excel BI stack. But that’s a conversation for another time.
.
A while ago, Ryan Goodman created and posted a few Flash progress indicators on his Xcelsius blog. These are Flash .swf files designed to be used as loaders for Xclesius dashboards.
.
I recently had an opportunity to work on a project where I could implement these loaders into an Excel dashboard as progress indicators – a lazy man’s progress bar if you will.
» More: Using Flash Progress Indicators
I’ve decided to dedicate this week to using Recordsets in Excel. Not to connect to external data sources, but to specifically using them to simplify internal Excel tasks.Â
.
Today, I’ll show you how to use Recordsets to help create a set of List Boxes that cascade values.
» More: Recordset Tricks in Excel 2 – Cascading ListBoxes
I’ve decided to dedicate this week to using Recordsets in Excel. Not to connect to external data sources, but to specifically use them to simplify internal Excel tasks.
Today, I’ll show you how I typically use a Recordset to fill a ComboBox with unique values from a table.
» More: Recordset Tricks in Excel 1 – Filling a ComboBox with Unique Values
I’m fresh from the DataPig Power Analyst Bootcamp. As usual, it was a blast. I’d like to give a shout out to Earl who taught me more than I really need to know about the chicken breeding business (he works for a company called Aviagen).
Â
Anyway, during the bootcamp, someone asked how they can work windows authentication into their Excel or Access application. It just so happens that I have a hack for that!
 » More: Use Windows Authentication for your Excel and Access Applications
