I was having a ‘mare with SQL today and I stumbled across this : http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/ I hope this helps people start to understand joins.
We are all told that using protection is a good thing. This applies to both real life and also programming, both in full OOP and the quasi OOP world of VBA / VB. It can be possible in some cases for your variables to be changed inside the sub / function you have called, even the ones one may have designated in your human mind as ‘input’ variables. This can lead to odd behaviour and hard to find bugs.
So.. what am I going on about? Well I am talking about passing by value or by reference. (Experienced VBA Programmers may want to skip this bit). In VBA you can use two keywords ByRef or ByVal when defining your Sub or Function.
Ok, in quick sucession here is another G Challenge. I think this one might be a bit of a stinker though! II (2) ;p Functions that can be called from Excel to convert a number to its Roman […]
Ok, my friend is trying to learn Excel VBA and get into RAD development. I am going to set a number of challenges which I am going to call a ‘G Challenge’ 😛 So the […]
After all my interviewing ( more on that to come ) I have a new contract. As such, a new bank and a new lot of things to learn. So while watching a training video […]
I had an interview today. I didn’t do all that well at all and I got a little bit schooled. This always seems to happen on my first technical interview with any serious technical ‘harrasment’. […]
I have been doing Excel VBA RAD ( Rapid Application Development) for over 4 years now, and I thought it would be useful to list all of the most useful resources that I have found over the years in one post. I guess as much for my own benefit as for other readers.
Professional Excel Development:
This has to be “The Bible” of all professional Excel developers. I am being quite bold in this claim.