PDF Print E-mail
Improving readability of worksheet data in Excel

 

It can be a big help if your data in Excel is easy to read (avoiding errors in calculations and or data analysis). I know there are more ways than one to achieve that goal, in this article I'll show you some code that handles the solution without using conditional formatting. It's a rough and simple solution...

Read more...
 
PDF Print E-mail
Convert MAC address in MS Access

 

Sometime ago I wrote an article about updating MAC Addresses before (Convert MAC address in MS Excel or OO Spreadsheet) so the subject is not new :-). But this time I'll try to explain how to Convert MAC addresses in MS Access. The standard format for printing MAC addresses in human-friendly form is six groups of two hexadecimal digits, separated by hyphens (-) or colons (:), in transmission order, e.g. 01-23-45-67-89-ab, 01:23:45:67:89:ab. In this article I'll give you examples of how to add, remove or change the separator for MAC addresses in MS Access.

Read more...
 
PDF Print E-mail
Rearrange columns in Excel using VBA
 

 

Did you ever need to rearrange or reorganize columns across multiple sheets in a certain order based on column headers? In this article I’ll try to explain how to rearrange columns in Excel based on column header information by using Visual Basic for Applications (VBA) .

Read more...
 
PDF Print E-mail
How to split numbers and text from a string in Excel

 

I received an e-mail from Marc, in which he asked me whether it is posible to split numbers and text in Excel.

Read more...
 
PDF Print E-mail
Using Wiican makes gaming easier in Linux

 

A month ago I stumbled upon a program called Wiican. Wiican is a fantastic program, or to put it more correctly it's a bunch of extremely powerful scripts, that makes your life easier using your Wii Mote in Linux.

Having my holidays within sight, I really didn't have time to give it a close look before I took of to France. “Luckily” I had some time during my holidays (read: I had some rainy days) to experiment and discover the power of Wiican.

So after a bit of fiddling I came up with a script that to use your Wiimote in First Person Shooter (FPS) games like Assaultcube, Sauerbraten, Warsow), etc.

Read more...
 
« StartPrev123456789NextEnd »

Page 4 of 9

Sponsored Links