#1 Using virtual machines
As a developer you always face the problem with different versions of MS Windows as well as different versions of MS Excel.
As a non-english developer you also face the problems with "international issues". The situation can sometimes be both
cumbersome and complicated.
So the main question is how to deal with it? The only answer is to have access to the
most frequent versions of both the operating systems and Excel.
We have several options to choose between.
However, no matter which solution we decide to use we need to buy legal copies of every software we intend to use, unless the
license rules explicit state otherwise.
The options we have are:
1) Using several computers. Usually we save the outdated computer(s) and use them as test-enviroments.
2) Dual boot on one cumputer, at bootup we can choose which operatingsystem we would like to run.
3) Virtual machines.
"Virtual machines" means that we have one operating system which acts as the host and where
we have several operating systems as virtual guests (e.g both Windows and Linux) on one computer.
The solution requires more RAM and more hard disk space but nowadays both these two items are considered as inexpensive.
Over a year ago I decided to use virtual machines and I was a little bit skeptical in the first place but changed my
opinion along the road.
In addition to the "usual" requirements: you have at least 512 MB RAM, but I highly
recommend using 1 GB for best performance. Each
operating system need a minimum 4-6 GB. If You plan to use databases or other softwares that require space then you need
about 8 - 12 GB available free space for each guest-operating system.
At least two software packages exist that do
the job in a nice and reliable way:
vmWare Workstation 4.5
This is the #1 software for working with virtual machines, which is also reflected in the
vmWare works excellent with Windows and outstanding with Linux. If You plan to run a mixed enviroment, i.e both Windows and
Linux then this software is the one and only.
With Linux, you should consider not using the latest version,
unless it's officially supported by wmWare.
I have no problems with USB-devices, shared folders, drag & drop and
accessing other network-resources. Neither with Windows or Linux as guest-operatingsystems.
Microsoft Virtual PC
Virtual PC only officially support Windows and as such
this limits its use with other operatingsystem like Linux. However, unofficially, Virtually PC works with most of the
Linux-distribution, although not as good as vmWare does.
In general, Virtual PC is a good option, especially if
you plan to only use Windows-systems and are not prepared to take a loan to get a copy of vmWare.
textfield to currency in userforms
Below is a code-example which shows how we can easily format
a textfield's value to the local currency that is used by Windows (via the settings).
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If Not .Text = Empty Then
Cancel = CheckNumeric(TextBox1)
If Not Cancel Then .Value = Format(CDbl(.Text), "Currency")
Private Function CheckNumeric(TxtBox As MSForms.TextBox) As Boolean
Dim stNumber As String
stNumber = TxtBox.Text
If IsNumeric(stNumber) Then
Select Case stNumber
Case Is < 0
MsgBox "The number must be greater then one.", vbExclamation
TxtBox.Text = Empty
CheckNumeric = True
Case stNumber - Int(stNumber) = 0
CheckNumeric = False
MsgBox "Only numerical values like 100 or 100,25 is acceptable.", vbExclamation
TxtBox.Text = Empty
CheckNumeric = True
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
#3 Kudos to Microsoft
On public forums, people usually express their disappointed about vendors & manufactures. Sometimes the critism is fair and
sometimes not. But we rarely give them any credits or do we?
Microsoft have done great work over the last 1 - 2
years by providing and sharing more information and knowledge about their software. We can all benefit from it and leverage
the use of their products in our daily work. In financial terms, we can express it as a higher return on investments (ROI)
Iīm very pleased with it and I can only hope Microsoft, will in the future, continue to support the global
community in this way.
The following URL are starting points and I highly recommend to visit them:
Microsoft Developers Center:
Microsoft Developers Library:
Microsoft Excel Developers (Check out the technical articles and the reference documentation):
Microsoft Knowledge Base:
The first really large project I got involved in was in the late 80's where I delivered a solution in the old macro-language,
XLM. Last week I got a call from the client who asked if I could add some additional features to it. The solution is still
running on a daily basis 12 months per year.
Last time I made any changes must have been 1993 or 1994 (at least what I can remember!) so no improvements have been made
over the years.
The amazing thing is that itīs still in use after more then 15 years, irrespectively of the rapid
developing of technoloqy and softwares. Itīs a great feeling that a solution you have created is still in use year after year
both local, nationwide and sometimes, also worldwide
The client has no intention to "upgrade" it as, "if it ain't
broken don't fix it"!
The less amazing thing is I need to recapitulate the old language but thatīs another
#5 The End
We are, more or less, all slowly dying due to age while some of us are doing it a little bit faster for other reasons.
If you have family members, friends and/or working colleagues who are facing the later situation, give them your time
and friendship as much as possible. It's the most valuable contribution we all can give no matter who we are, where we are,
or how much money we have.
Finally, by living, you put yourself into a high-risk project but the benefit of living
can't be measured, so turn off the d... computer(s) and take part in life!