Wednesday, March 28, 2007

Finding the last data cell in Excel 2007

Using VBA use the Range.SpecialCells Method such as

RCount = ActiveCell.SpecialCells(xlLastCell).Row
CCount = ActiveCell.SpecialCells(xlLastCell).Column
ActiveCell.SpecialCells(xlLastCell).Select

Friday, March 23, 2007

Renaming WSS 3 Sharepoint sites (webs)

I'm building a Sharepoint MOSS 2007 environment and found that one of the sites I had created had the wrong name. I began looking around to see if I could migrate the content from one site to another easily which didnt look promissing. I then found that I could rename the site using STSADM.EXE Something like
stsadm -o renameweb -url http://portal/[oldname] -newname [newname]

Brilliant, (remember to change the site title as well) and its job done !

Wednesday, March 21, 2007

Dark Blue Duck | Scanning Enabler (TM)

Dark Blue Duck Scanning Enabler (TM): "Scanning EnablerTM Product enhances SharePoint adding support for Desktop Scanning"

Whilst this is and interesting product im not sure why you wouldnt just scan your files directly to an WSS URL document library instead. I must be missing something.

Sunday, March 18, 2007

ScottGu's Blog : New C# "Orcas" Language Features: Automatic Properties, Object Initializers, and Collection Initializers

ScottGu's Blog : New C# "Orcas" Language Features: Automatic Properties, Object Initializers, and Collection Initializers

Interesting C# 3 new bits

WSS 3 anonymous setting

I couldnt find an easy way to enable Anonymous access after setting up a WSS 3 web application. I couldnt find anything in the book references but this article gives the steps to explain what is needed.

Firstly you need to go the WSS3 Central Administration -> Application Management-> Authentication Providers section and edit the default zone properties to allow anonymous. This has the effect of allowing anonymous in the IIS Service manager -> Web -> Directory Security section.

Then you need to enable the setting on each Site Collection. You do this by going to the collection and choosing Site Actions -> Site Settings -> Users and permissions -> Advanced Permissions -- and enable anonymous access under the "Settings" drop down.

This last step isnt very intuative and I didnt find it until I read this article

Sunday, March 04, 2007

Saturday, March 03, 2007

Changing SQL Server 2005 language

SQL Server Forums - Changing SQL Server 2005 language: "EXEC sp_configure 'default language', 23 RECONFIGURE"

PCTV To Go HD Wireless

Pinnacle Systems - Product summary - PCTV To Go HD Wireless: "PCTV To Go HD Wireless" Ive been looking for an HD transmission system for some time and this solution seems to solve this with a combination of slingbox type web tranmission as well.

CHM Page cannot be displayed

Ive often had frustrating problems with CHM files not expanding their pages properly and endedup routing round various PC's trying to find one that would work. Thanks to Dennis Crane for suggesting re-registering the CHM viewer "regsvr32 hhctrl.ocx" which did the trick ! CHM files: The page cannot be displayed error

Tuesday, February 20, 2007

YouTube - Web 2.0 ... The Machine is Us/ing Us

This is a very good clip on the fundementals of XML. (Boring I hear you say! - watch it and judge afterwards)

If you every have to persuade anyone that digital is better than paper then the first 30 seconds are a must !

YouTube - Web 2.0 ... The Machine is Us/ing Us

hello its liam (trainbloggin) : MOSS2007 + GROOVE2007 – Document Conflicts

hello its liam (trainbloggin) : MOSS2007 + GROOVE2007 – Document Conflicts

Saturday, February 10, 2007

VMTN Top News

VMware 6.0 beta 3 available - looking forwards for the full release especially as the Host can be vista

Thursday, February 08, 2007

Sunday, December 17, 2006

Insufficient System Resources Exist to Complete the API

My Toshiba M400 laptop is forever running out of battery or seemingly turning itself on again in its bag after suspending due to this error - Insufficient System Resources Exist to Complete the API.

Thanks to Bart at RedGate for finding an obscure MS KB article about it. MS patch for Win XP SP2

A copy of the MS hot fix is available here