June 2008 - Daily Dose of Excel

Daily Dose of Excel

Home

Syndication

News

This site is published here by kind permission of Daily Dose of Excel's owner Dick Kusleika

Archives

Sort by: Most Recent | Most Viewed | Most Commented

Identify Empty Cells in VBA

Whenever I need to determine if a cell is blank, I call the IsEmpty function on the Value property. If IsEmpty(ActiveCell.Value) Then This anonymous blogger uses vbNullString. If ActiveCell.Value = vbNullString In other news: In Firefox, Cntl+Click on a hyperlink and it will open that link in a new tab. Except for the aforementioned blog's heading. [...] Read More...

Published Thu, Jun 26 2008 10:01 AM by Daily Dose of Excel

Filed under: VBA
Create a QueryTable from an Excel Source in VBA

Elton is trying to create a QueryTable based on a named range in a closed Excel file. When the code tries to refresh the QueryTable object, he gets an SQL Syntax Error message. Although he's sure his SQL syntax is correct, it's almost certainly not. The syntax you get from the macro [...] Read More...

Published Tue, Jun 24 2008 9:03 PM by Daily Dose of Excel

Filed under: VBA, External Data
Using an Analysis Template — Updating the data source

The motivation for this quick and incomplete draft was Dick Kusleika’s post on distributing/communicating a PivotTable template (http://www.dailydoseofexcel.com/archives/2008/05/21/pivottable-markup-language/). In the approach I’ve adopted for the past few years, the basic idea is to separate the data from the analysis and presentation. Then, a simple piece of code lets one update the data connections in [...] Read More...

Published Sat, Jun 21 2008 1:56 AM by Daily Dose of Excel

Filed under: General
Read More...

Published Fri, Jun 20 2008 9:33 AM by Daily Dose of Excel
Excel Blog Happenings

The Contextures Blog has moved off of the wordpress.com domain and onto the contextures.com domain. Check it out if you haven’t, update your feeds if you have. PTS Blog is holding a contest for physics and engineering spreadsheet models. Since I’ve mentioned it on my blog, I get to submit six entries. I’m [...] Read More...

Published Wed, Jun 18 2008 1:24 PM by Daily Dose of Excel

Filed under: Links
On-the-fly data entry form

Hi all, So after Dicks (nice to read) rambling on golf, let’s do some Excel/VBA stuff again. I intend to get a bit of discussion on this one, so bear with me. I’m currently developing an Excel workbook for a customer. One of the interesting things with this project is that it consists of multiple data tables, each [...] Read More...

Published Wed, Jun 18 2008 6:46 AM by Daily Dose of Excel

Filed under: VBA Advanced, VBA, MVP, Userforms and Controls
Alive and Well

Howdy. It’s been quiet at the ol’ DDoE lately, but I thought I would check in and let you know I’m still around. I generally slow down a little in the Summer, but this Summer has been surprisingly busy. I have some nice Excel posts in the queue. In the mean [...] Read More...

Published Wed, Jun 18 2008 12:02 AM by Daily Dose of Excel

Filed under: General
Settling Debts

You owe me $325.00 as of 1-June. Instead of paying me, you note that I will owe you $778.00 on 12-July and that we should just settle up then. I, being an accountant, suggest instead that we settle up on 10-Aug. Here’s one way to find that date: Start by setting up a [...] Read More...

Published Fri, Jun 06 2008 2:31 PM by Daily Dose of Excel

Filed under: Financial Functions, Goal Seek
Variable Hyperlinks

Excel provides an easy way to create a table of hyperlinks and even save the workbook as a web page. The built-in method for creating a hyperlink is Insert > Hyperlink (Ctrl+K). The problem with this method is mass changes, like renaming your server. Editing each one (if you have a lot) [...] Read More...

Published Wed, Jun 04 2008 2:53 PM by Daily Dose of Excel

Filed under: Formulas, List and Table Functions, User Defined Functions, Hyperlinks
Fixing Links To UDF’s in Addins

Hi All, Excel has a host of built-in functions to help you do your computations. But sometimes you need to write your own functions using VBA. These functions are called “User Defined Functions” (UDF). UDF’s typically are placed in addins. As long as the addin is installed, the UDF’s work as expected. You get into trouble [...] Read More...

Published Mon, Jun 02 2008 1:45 PM by Daily Dose of Excel

Filed under: VBA, MVP, Downloads, Add-ins, User Defined Functions

June 2008 - Daily Dose of Excel

Syndication

Recent Posts

Tags

News

Archives

Identify Empty Cells in VBA

Create a QueryTable from an Excel Source in VBA

Using an Analysis Template — Updating the data source

Excel Blog Happenings

On-the-fly data entry form

Alive and Well

Settling Debts

Variable Hyperlinks

Fixing Links To UDF’s in Addins