March 2006
M T W T F S S
« Feb   Apr »
 12345
6789101112
13141516171819
20212223242526
2728293031  

Archives

Archive for March, 2006

M.I.E Colour Pallet

( General and Addins and Downloads )

Looking at the new colour themes in Excel 12 reminded me of a tool I put together a while ago. It’s a colour pallet type tool which lets you build a set of colours in the same range - it’s useful for designing report and the like. Anyway here it is - the help tells […]

Development time and value to business.

( General )

I am in the middle of updating a set of business tools used within the company I work for. The particular code I’m working on deals with post codes, it makes an attempt to correct invalid postcodes and points out one which seem suspect. A couple of things struck me about the time I will […]

Running Other Programs from Excel

( General )

Hi, Been really busy both at work, and at home recently so I have not had as much time to blog as I would have liked. Things are still very very very hecktic, but, I'll try hard to put some posts up... to wit:
You can use the Shell command to run programs on your pc, [...]

New Master Head

( General )

A very big thank you to Simon over at www.doodleblog.co.uk for the new masterhead, very cool I'm sure you'll agree.
Thanks Simon!

Spell checking in user forms

( General )

UPDATE!
If you downloaded the example file, you may have noticed that it didn't quite work properly - somehow a line of code had gone missing - I've updated the example file now so it should work ok.
---------------------
I have a report file I send to colleges, I don’t want it to look like “just another spread [...]

VB.net Learning Videos

( General )

The thing with MSDN it that there's loads of good stuff on it, you just have to spend about 6 hours to get to it. So of these look good, eps. towards the bottom:
"This video series is designed specifically for individuals who are interested in learning the basics of creating applications using Visual Basic [...]

New Access

( General )

Just a quicky:
http://blogs.msdn.com/access/default.aspx
MS blog about new Access if it's as good as Dave's Excel one, it will be fantasic!

Click to install Addin

( General and Addins )

The following code will install an addin to the users local addins folder. There are two constants that need to be changed, well only one really if your installing a .xla. You will also need to modify the call to "Addcustommenu" which appears twice - make a call to your menu/entry points code.
The code actually [...]