This morning one of my add-ins kept giving me Run-time error ’438′; Object doesn’t support his property or method. I would click OK, and the error would immediately pop up again....

continue reading...

Following up on my previous posts sharing my initial Excel mashups (http://www.dailydoseofexcel.com/archives/2012/01/29/excel-mashup-2/ and...

continue reading...

There are a few programs whose output I can identify immediately. One is Quickbooks. When I get an invoice or a quote from someone using Quickbooks, I know it right away. Today, I was admitted to the...

continue reading...

I currently have Excel 2003 and Excel 2007 installed. I’m pretty happy with this arrangement from an Excel standpoint, but Word and Access are always trying to install themselves. Happy or not,...

continue reading...

Following up on the previous post (http://www.dailydoseofexcel.com/archives/2012/01/25/excel-mashup-1/) I extended the capability to create a Polar plot using a 2nd worksheet in the same workbook....

continue reading...

Ross is live blogging the Excel Dev Conference in the UK. It’s already after lunch over there, but if you’re interested, check it out.

continue reading...

Recently, Microsoft introduced a way to create a “mashup” using Excel. Fellow MVP, Jan Karel, put together a tutorial on how he created his first mashup. It helped me understand the...

continue reading...

HTML5 provides for fractional representation of halves, thirds, fourths, fifths, sixths, no sevenths, and eighths. Excel has a fractional number format. This post is about bringing these concepts...

continue reading...

I’ve been searching for a new search engine in the wake of Google’s ‘plus’ enhancements. I’ve tried blekko, ixquick, and I’m currently using DuckDuckGo....

continue reading...

Someone in Microsoft’s Excel forum had a question for which I don’t have an adequate response. In A2:A7 enter the values: 6494.55 1311.36 198.08 124.9 131.81 131.81 In A1 sum the values...

continue reading...

For several years now, Google has shown ads on my website and when someone clicked on one of the ads, it shared with me some of the revenue it earned.  For some time now I have had the impression...

continue reading...

If you export a Profit and Loss statement from Quickbooks to a CSV file, you get dates that look like this: Excel turns them into this. January 2005 becomes January 5th of the current year. February...

continue reading...

You’ve probably watched The Price is Right TV game show. On it they run the Clock Game. The game is played for two prizes. The actual price of the first prize is shown to the studio and home...

continue reading...

Depending on the requirements, I’ll choose a method for populating my custom collection classes using from data from a worksheet. In this example, I’m using a list of the best selling...

continue reading...

I have a utility that determines the date of the upcoming Friday. It used to look like this dtReturn = Date + 8 - Weekday(Date, vbFriday) It has served me well for many years. Until this year. This...

continue reading...

I have a pretty simple procedure that I run a few times every other week. Someone emails their timesheet to me, I open the timesheet in Excel, and I want a quick way to save it to the proper...

continue reading...

Oh, Wait! Excel doesn’t have those functions. We’ll have to roll our own. We’re going to use the Double Unary tip found here. In Excel, 1*TRUE = 1, 0+TRUE = 1, TRUE^1 = 1, and...

continue reading...

I’m tired of trying to remember the library names and the syntax for doing this. I’m putting here so when I search for XMLRequest, Web Request, HTTPRequest, I can find it. Sub GetData()...

continue reading...

Hi everyone! As you may have seen on some blogs, Microsoft now enables you to include any Excel file -or parts thereof- in your web pages and blog posts. For example (yes you can make changes to the...

continue reading...

If you’re in or around London in late January, don’t miss the UK Excel User Conference. It’s Wednesday, January 25th at Skills Matter Here’s the agenda. Check out this gem...

continue reading...