Monthly Archives: May 2010

Microsoft Outlook: Calling VBA Class Module function using VBScript

Filed under Uncategorized

Microsoft Outlook: Calling VBA Class Module function using VBScript

This article describes how to call a VBA Class Module function from VBScript.  An example of where this may be used is to call a function from a module or macro (VBA) using code in an Outlook form (VBScript).  The example code provided in the article creates an “Outlook.Application” object, which is then used to call the function within a module in Outlook.

Free Php RSS 2.0 feed generator class (RSS2Writer)

Filed under Uncategorized

Free Php RSS 2.0 feed generator class (RSS2Writer)

A free Php script to generate RSS feed XML.  A Php RSS2Writer class file is provided which contains functions required to generate an RSS 2.0 feed which can include a Title, Description and feed items which also have a selection of optional paramaters such as the date/time the feed content was last updated and categories/tags for each item.  A sample controller is provided which includes some instructions for using the Php RSS 2 Writer.

VBScript String Clean function – remove or replace illegal characters

Filed under Uncategorized

VBScript String Clean function – remove or replace illegal characters

This article provides a function written in VBScript which removes illegal characters from a string.  The illegal characters are specified in an array at the beginning of the function.  The function is passed the string which may contain illegal characters, which then processes the string to remove or replace any illegal characters.  The code also allows you to specify the character or word which will replace specific illegal characters.   The illegal characters provided in the function are included for processing strings which will become the filename of a document or list item in SharePoint, which has a number of characters which are not accepted.

Free online webmaster, web development and web design tools and resources

Filed under Uncategorized

Free online webmaster, web development and web design tools and resources

Tools and resources for Webmasters, web development and programming tools and resources, web and graphic design tools and resources to help when designing and developing websites.

XML Parser

Filed under Uncategorized

XML Parser

Php code to load and process an xml file. Each element name and value, including all attribute names and values are displayed in the browser.
This can be used as a starting point for loading an xml file and accessing elements and attributes.  This can be used as a reference to help when writing a Php script that parses and XML file from a file or web address.  As the XML file is parsed, the name of each element in the XML file is displayed, along with the value and any attributes (including values) that the element may have.  Sample code is provided in the article.

Php: Log Clicks on Links to External Sites

Filed under Uncategorized

Php: Log Clicks on Links to External Sites

Log users clicks/actions before they are taken to the desired address. Php code uses a MySQL database and the PEAR MDB2 package to connect.  If you need to keep track of clicks on links to external websites, the Php script provided in the article can be used to log the details of the link to a table in a MySQL database.  This data can the be used to determine which external links on your site are most popular.  The script takes the ID of an item from a MySQL database table, which is then used to retrieve the information (url) for the link which a user clicked on.  The ‘hit’ is logged to the database table with the ID of the item which was clicked on, along with the date and time of the click.

SEO – Crawler interpreting external links

Filed under Uncategorized

SEO – Crawler interpreting external links

This article relates to the article Php: Log Clicks on Links to External Sites .  Details are provided to allow external links on a site to be enconded as the url of the external address, then use JavaScript to catch the click and redirect to a Php script which logs details of the click (link/time) to a database table for use in statistics, reporting and to determine popularity of items in a database.

XML-RPC Blog Ping

Filed under Uncategorized

XML-RPC Blog Ping

Submit sites and RSS feeds to directories using this Php script, which uses XML-RPC to call the “weblogUpdates.ping”, or “weblogUpdates.extendedPing” method of Web Services on Directory websites. The article also provides a link to a Java application which can ping up to 1000 XML-RPC servers with details of a site, including the titles and description, RSS feed and Changes URL.

Search Engine Optimization (SEO) Tips for Blogger

Filed under Uncategorized

Search Engine Optimization (SEO) Tips for Blogger

SEO Tip for Blogger Users: Add post labels/tags to the keywords and description meta tag of your Blogger blog.  Display additional information in the title of each post, and switch the order of the post and blog title so that the post title is first, then the title of the blog.  This will help increase traffic via search results, as there will be more information about the post displayed in the title of search results allowing users to easily know what they are looking at.  As each post in a Blooger blog can be tagged with multiple lables/categories, these are perfect to be used for the keyword metatag, as it will contain a set of relevant keywords dynamically for each post, and will not display for search/category pages or the homepage.  A custom value can be provided to the keyword and description tags of the homepage for the blog.

IE / Firefox Alignment Issues Solved

Filed under Uncategorized

IE / Firefox Alignment Issues Solved

Having trouble getting IE and Firefox to display a website the same?  This article describes how to set the alignment of elements on a webpage so that both Internet Explorer/IE and Firefox will display the element centered.