excel

5 Days of VBA – Day 4: Excel Protect/Unlock all Worksheets

Mar 23, 2011Comments off

So it’s day 4 of 5 and I’ve decided to go Excel VBA…… The following code snippet will allow you to protect or unlock all

excel

5 Days of VBA – Day 3: Table Manipulation using VBA

Mar 22, 2011Comments off

Day 3 and I’ve decided to continue with Access VBA and focus on using VBA code to manipulate tables. Here’s a few one line code

excel

5 Days of VBA – Day 2: Exporting data from Access to Excel

Mar 21, 2011Comments off

Right, it’s day 2 and so I’ve decided to focus on one of the most useful pieces of VBA code I can think of which

excel

5 Days of VBA – Day 1: Return a record count

Mar 20, 2011Comments off

VBA is not the golden boy of programming but if you’ve had the pleasure of working in a corporate environment with non-techie people it can

javascript

JavaScript Popups

Mar 19, 2011Comments off

JavaScript popups are all over the net and if you’re creating a site, chances are you may want some kind of easy popup code, so

code

Simple JavaScript and PHP Refresh Page Code

Mar 17, 2011Comments off

Looking for a simple way to refresh a web page in code, Javascript or PHP? Then here’s the simplist way you can do that: Javascript

comline

Control IIS from Command Line

Mar 09, 2011Comments off

The following commands will be useful for any server admin looking for quick access to basic IIS functionality. Usage:     iisreset [computername] /RESTART –

rdp

Windows 7 – Web-based Remote Desktop

Mar 08, 2011Comments off

Here’s a handy guide for all those who have finally made the jump to Windows 7, setting up a web-based remote desktop interface through IIS

mo

Outlook System Folder Names

Mar 08, 2011Comments off

Ever imported a mailbox into Outlook only to find that all of the system folders (Junk Mail, RSS Feed, Outbox,etc) have been duplicated and therefore

server

SharePoint 2010 – Physical Versus Virtual

Mar 09, 2010Comments off

The obvious advantage to virtualisation is the reduction in hardware costs though the following needs to be considered. Virtualizing Web servers and application servers The

search2

SharePoint 2010 – Overview of the Advanced Search Functionality

Mar 08, 2010Comments off

Sticking with the theme of the week, SharePoint 2010 Search functionality, here is a overview of the functionality and enhancements. SharePoint 2010 includes all of the