Back in the old times when I programmed in VBA/ VB sometimes there was the necessity to use … workarounds. A very popular especially in Excel development was DoEvents. Have a look onto this official sample by Microsoft: ‘ Create a variable to hold number of Visual Basic forms loaded ‘ and visible. Dim I, […]
Category: Excel
Microsoft Graph & Excel API: Waterfall Charts with d3js as Office 365 Addin – is that already stable?
Did you hear about Waterfall? No, I don’t mean the oldschool development practice of the NASA to ensure that a rocket-powered aircraft will fly in space forever. I mean Waterfall charts: These charts do add some value for business users as they are different. They do not just show data, they show data with a […]
Running macros in Excel from c#
Here we go again, it’s Excel and sometimes I feel like Peter Pan tries to catch his own shadow. You may not believe it, but a shadow can have some kind of grip. The day before yesterday one sales guy called me. As usual, these guys are in a hurry. Next day there is a presentation, […]
Programming and Intuition, Part II
May you read the first part of Programming And Intuition. I promised to add some more experience about that and it didn’t take a long time for getting into a situation again where intuition and experience helped me a lot. This time at a different customer. Certainly it is pretty easy in the Excel ecosystem […]
Programming and Intuition? Come on.
Intuition and programming? Are you serious? Maybe it sounds odd in the first run, but I often have a certain kind of .. let’s say instinct when I watch code to find out where the cause of a problem is. It is something behind the scenes telling me I should concentrate on a little fact. This […]
Race issues – application crashing and user interaction
Today was amazing. I’ve been in the office again, had some really promising chats with team members and everything looked good. I was short before getting back to the airport to catch my flight back to Düsseldorf, when… Murphy was there. Pretty much visually. He reincarnates in a log file like this: 2014-11-18 09:48:34,236 [6] […]