If you are an HSBC customer you will already know that getting old statements out of the online banking system is a nightmare. You can download recent statements as CSV files but any statements considered "Previous" are not available for download.

You can view them on the screen but what if you want an electronic copy for your records?

It would be great if HSBC allowed you to download your statements as PDF files every month as American Express do.

So what can you do instead?

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

The example script can be used as a base for processing CSV, HTML and XML files.