Daily posts of Excel tips…and other stuff
Archive for the ‘Polls’ Category.
Someone asked if anyone automates Office applications any more. That struck me as kind of funny. If I had to guess, I would guess that there are more lines of VBA code (poorly written or not) that automate Office applications than all the COBOL, VB6, PHP, and any other language you can think [...]
Via the US ISV Developer Team Blog
Microsoft Office 2007 SP1 will be available for download Dec 11. The improvements in 2007 Office System SP1 are in response to direct feedback from power users at large organizations or indirect feedback from home and Office users through the Dr. Watson bug-reporting system.
I haven’t seen any details about [...]
OK everyone.
Here is a (poorly designed) chart showing the result so far.
It looks like the icons at the top are winning. I agree however that for beginners, buttons with text might be better.
I have cooked up an option D though. What about this one:
So which is it? A, B, C or D?
Regards,
Jan Karel Pieterse
JKP Application [...]
Hi everyone,
I’ve had some remarks about the design of my Name Manager.
Because it has so many functions, I (to be more precise, we: Charles Williams and I) had a hard time cramming it al into one user interface.
Because (in my opinion) this is a tool aimed at the more proficient Excel user and even more [...]
Based on the comments and emails, I think I know how this one’s going to turn out. Should Daily Dose win, the second place finisher will win the prize. Voting starts when you can see this post and ends promptly at 8:00PM CDT (GMT -5, I believe. But don’t quote me [...]
Jonathan had an excellent comment in the Principal Payment post. Why create an array formula when the Analysis Toolpack already has the CUMPRINC function. Well, I said I couldn’t find a function to do it, and I wasn’t lying. That doesn’t mean one doesn’t exist, only that I couldn’t find it.
The reason [...]
I’ve been thinking a lot lately about when I will stop writing code that works in Excel 97 (like the Split function, for example). I’m interested in to see what other people are doing.
When will you stop writing Excel97 compliant code?
I already have.
After the next version.
When I/my company upgrade(s) from 97.
When nobody on the [...]
