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 …
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 “HKCU\Software\Microsoft\Internet Explorer\Main\Start Page”, StartPage…
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.…
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")…
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 also from their website, you’ll find …
Well, what exact business benefit is there for not ensuring the presentation layer is ‘fit for purpose’? To build a “web” based application meeting all specific requirements and policies in regards scalability and the like – then …
