Here’s a little code snippet to export an HTML table to MS Excel through utilising ActiveXObject(“Excel.Application”) from Internet Explorer.

The JavaScript (in this case utilising Microsoft’s JScript) runs over the table displayed pulling out the relevant data and exporting into the instantiated copy of Excel. This is a working example…

Organisations anticipate a return on the investment involved in implementing Intranets expressed in financial terms or intangible benefits; an expectation their Intranet will either save money, enhance efficiency or both.

Organisations however, are not cohesive bodies with unified needs or interests; instead they are formed by individuals, each with their own…

Have you noticed how the “out the box” solution to export your dataset from MS Access to MS Excel doesn’t give much room to give custom headers to your worksheet?

Through utlising ActiveX you can instantiate a copy of MS Excel in memory to add in your own custom headers…

Is it just me or has google added a margin around their search results? An ID of ‘gsr’ on the body tag appears to apply ‘margin: 3px 8px;’ bumping the results in at each side!

Clocked this on Tuesday night and thought it was a mistake with my setup or…

Stuck in a restrictive environment where you can’t alter your homepage settings? Check out the below WSH shell script to alter your homepage in Internet Explorer via the registry:

Set WSHShell = WScript.CreateObject(“WScript.Shell”)
‘ home page URL
StartPage = “http://www.yaduk.co.uk”
WSHShell.RegWrite “HKLM\Software\Microsoft\Internet Explorer\Main\Start Page”, StartPage
WSHShell.RegWrite…

Below is a great code snippet to process XML dynamically through an XMLHttpRequest (XHR) request. From this further XSLT processing can be applied dynamically utilising Internet Explorers “fragment” transformations.

/* XHR Connector */
XMLReq = function() {
this.adapter = false;
/*@cc_on @*/
/*@if (@_jscript_version >= 5)
try {
this.adapter =

…

Information Architecture and Information Retrieval

Intranet information retrieval requires more often than not implicit end-user understanding to the nature and location of information sought since architecturally information organically mirrors organisational layout rather than information ‘typing’. Semantic linkage and intelligible meta data unfortunately take a back seat. As a result it is…

Excellent post in the MSDN microsoft.public.excel.programming community regarding the splitting of a firstname and lastname into two seperate columns.  The honours go to someone called “Bam”.

Last Name
=IF(ISERROR(LEFT(B2,FIND(“,”,B2,1)-1)),RIGHT(B2,LEN(B2)-(FIND(” “,B2,1))),LEFT(B2,FIND(“,”,B2,1)-1))

First Name
=IF(ISERROR(RIGHT(B1,LEN(B1)-(FIND(“,”,B1,1)+1))),LEFT(B1,FIND(” “,B1,1)+1-1),RIGHT(B1,LEN(B1)-(FIND(“,”,B1,1)+1)))

A few folk have asked how to just connect automatically to Essbase from Excel VBA. Please find below a simple VBA sub stripped back to show this. Use the following to initialise with your own details in place.

Call initialise("xxx","xxx","xxx","xxx","xxx")

Declare Function EssMenuVRetrieve Lib “ESSEXCLN.XLL” () As Long
Declare Function

…

Having used GUP from Netlobo http://www.netlobo.com/comments/url_query_string_javascript for some time to pull back parameters from the URL in JavaScript for fiddling with, I decided to create a handy JQuery extension for reuse.

Extending this further with the gpn section to get all parameters, which is…