Bespoke Programming Solutions

As the programmer behind the Chestysoft components seen on this website I have over 20 years' experience in a variety of software fields and I can be hired at competitive rates. I am based in the United Kingdom and am VAT registered.

My work falls into the categories outlined below.

VBA in Microsoft Office Applications

I write VBA macros to automate Excel, Word and Outlook.

Excel

Most of the work I get asked to do is data crunching in Excel. This may be to import data from various sources (e.g. other Excel files, CSV, text, XML, etc.) into Excel, possibly while applying some logic to the data. Alternatively, data may be sent the other way into a format that will be used by some other application.

Another common branch of Excel work is to streamline a data entry process by using a form.

Microsoft Word

Word can be automated to produce documents dynamically, often combining data from another source, such as Excel. The built in Mail Merge functionality is very powerful but sometimes some additional logic is required, and that is when VBA can be used.

It is also a frequent requirement to extract data from Word and present it in a summarised form, such as Excel.

In both Excel and Word there are endless possibilities for automation, and on a Windows platform it is possible to draw on other components or API commands that are native to Windows, but not to Office. I would be happy to discuss any requirements.

Outlook

Outlook is more difficult to use with a macro due to the security limitations and the method of importing a macro. There are still occasions when a macro can be a powerful automation tool. It is possible to read mail from folders or to create and send new messages, while integrating with the other Office applications.

ASP Development

I have extensive experience with Classic ASP from developing and troubleshooting components, but I no longer produce complete applications. I would be interested in adding specific functionality to an existing application or making minor changes or tracking a bug.

Custom Development of COM and ActiveX Components

If you have any programme logic that needs to be wrapped into a COM or ActiveX component, I can do this using Delphi. Components can be either 32 bit or 64 bit. The COM or ActiveX wrapper is relatively easy to produce so the complexity of the project depends on the programme logic that is required.

Contact

To discuss project requirements and to get a quote, contact:

Simon Chester
Email: info@chestysoft.com
Tel: 07940 797432

Example Projects

Example 1 - An example of importing data into Excel using VBA.

Example 2 - An example of a VBA macro to create a Word document taking data from Excel.

Example 3 - An example of adding REST functionailty to an ASP application to make API calls.

 

 

© Chestysoft, 2018.