Quote from someone that is not me and not my particular issue, but that expresses the sort of problems endemic to Excel and MS software in general:
"When data is refreshed, I get a message box "Send a Frown" at unpredictable, inconsistent intervals. For example, it will work seamlessly for five or six times then suddenly it will fail, and give this "Send a frown" message.
A normal VBA error handler does not deal with this "Send a frown" message. Not even an "On Error Resume next" deals with it. I can thus not capture or step-over the error (err) and deal with it in my code. When the "Send a frown" message appears, the entire process is on hold until I (the human) clicks on "Send a frown" or "Cancel". This is problematic since this process runs 3am in the morning on our servers for about 200 connection refreshes."
It definitely isn't fancy but it works well for larger files and things like column mode and perl regex searches are just so nice in certain cases. I'm finding it hard to put down especially since I do a lot of Perl and I haven't found a big benefit for an IDE there.
Open a 200mb horribly formatted text file. Apply some regex find-replace to remove some cruft. Let UE format it into nice columns. All seamlessly, also for huge files.
I've kept UltraEdit around for more than 20 years now. Column editing, especially back when it was introduced, saved my bacon more than a few times.
- UltraEdit. What Photoshop is to images, UltraEdit is to text. The weird thing is, it’s not a super flashy or even immediately intuitive tool. But once you get the hang of it, it never fails to deliver.
- Excel. It’s insane the breadth of stuff you can do with it. And as a tool, it’s equally handy and “oh my God this will save me so much work” for a school teacher as it is for a data analyst and stock broker. It sort of scales infinitely, there is always one more level of complexity/usefulness to unlock.