Dailydoseofexcel - dailydoseofexcel.com - Daily Dose of Excel
General Information:
Latest News:
Importing Fixed Width Text Files with ActiveX Data Objects 10 May 2013 | 04:13 pm
A few weeks ago I was struggling with fixed width text files. Remember 1995? Me neither, but I’m living it every day. I happened upon a stackoverflow.com post that dealt with using ADO for this purpos...
Importing Fixed Width Text Files 9 May 2013 | 02:34 am
I’ve been working with fixed width text files quite a bit lately. The built-in method for importing these files is terrible. First, it’s yet another wizard and I think it would be better as a single f...
Queen’s day sale 29 Apr 2013 | 07:58 pm
As some of you may know, I’m Dutch and live in “The Kingdom Of The Netherlands”. Well, tomorrow is an important day for the Dutch people: Queen’s Day. More so, tomorrow is an extra special day. Not be...
Draw a circle in an Excel chart 28 Apr 2013 | 07:24 am
By default, Excel has a limited number of charts. That does not mean that those are the only charts one can create. It turns out that with a little imagination and creativity, we can format and config...
Analyze ‘free’ money 25 Apr 2013 | 07:40 am
Recently, I received yet another promotion from yet another company offering me money at zero percent interest with the predictable asterisk next to the zero percent. Instead of just shredding the off...
Date Picker Add-in for Excel 2011 for the Mac 21 Apr 2013 | 11:19 pm
Hi all I upload a Date Picker add-in based on John Walkenbach’s Date Picker on my site for the Mac, this Date Picker will also be a part of to the PUP add-in for the Mac soon. This Date Picker for Mac...
Stop Replying to Yourself 17 Apr 2013 | 02:01 pm
In this edition of How to Make Outlook More Like GMail, I address the problem of replying to a message that you have sent. Inexplicably, Outlook creates a message addressed to you. That make sense fro...
Excel corrupts certain workbooks in migrating from 2003 to 2007 14 Apr 2013 | 08:04 am
I got a email from a client asking for help because Excel was “destroying,” to use his terminology, his 2003 workbook after conversion to the 2007 format. And, after analyzing the kind of change Excel...
Almost There 12 Apr 2013 | 10:22 pm
Look how close I am. It’s like the odometer rolling over on my car.
Sample Fixed Width Text File 12 Apr 2013 | 12:49 pm
I have a post or two in my head that deals with fixed width text files, something I’ve been dealing with quite a bit. Like me, you probably don’t run into fixed width text files in your personal life....
