List All Files In Folder Using VBScript

If you need to create a customised file listing from a folder you can use the following VBScript. It outputs file information to a text file. This can be modified to create XML or CSV outputs.

[Read More]

VBScript Function Left Right Pad Strings

Here is a VBScript function to left or right pad a string with a specified character. It is useful for creating formatted columns of text in outputs from VBScript scripts.

[Read More]

Remove Hyperlinks From Spreadsheet

With the default settings Excel will replace text with a hyperlink whenever it thinks you have entered a URL, email address or network path. This feature can be extremely annoying.

[Read More]

Word Macro To Replace Template Documents

If you need to bulk update a whole directory of Microsoft Office Word documents to point them to a new template then the following macro allows you to set the template to 'Normal.dot' in bulk.

[Read More]

Saving HSBC Statements To HTML And CSV

If you are an HSBC customer you will already know that getting old statements out of the online banking system is a nightmare. My macro allows you to obtain CSV and HTML versions of your statements.

[Read More]

Read And Write Text Files Using VBScript

This example code shows how you can use VBScript to read and write standard text files. It can be used for reading lines from one file, processing them and then writing them back to another file.

[Read More]