Visual Basic Programmer

VISUAL BASIC Programmer SKILLS

Microsoft Office and Visual Basic for Applications

The Microsoft Office products consist of Microsoft Outlook, Microsoft Access, Microsoft Word and Microsoft Excel. Their functionality is different, yet all conform to the standard of Microsoft Visual Basic for Applications (VBA), providing a consistent programming interface.

Microsoft Word Programming

• Supported and enhanced the Microsoft Word Process Picture Map software of Talsico. See the Talsico International page.
• Supported and enhanced the Microsoft Word G.E.T. valuation system. See the Gray Eisdell Timms page.
• Created a command driven Quotation system. See the Masterton Homes page.

Microsoft Outlook Programming

• Developed an Email Reply application using Microsoft Outlook and Microsoft Visual Basic for Applications. A Combo Box was set up in the Standard Menu, which allowed selection of different Replies.
• Created an automated mail scan of the Microsoft Outlook InBox, and updated a Microsoft Access database with details contained in the mail.
• Created a procedure to analyse Junk Mail into possible valid mail and probable valid mail. The remainder are moved to the Deleted Items folder.

Microsoft Excel Programming

• Extracted records from numerous Microsoft Access databases and SQL Server databases to Microsoft Excel worksheets.
• Created an Asset Valuation system in Microsoft Excel. This involved the importing of Word Documents, and modifying each paragraph with Indents and Bullets to fit into the Microsoft Excel column and Row. Imported pictures, and resized them into thumb print arrays.
• Created Microsoft Excel functions to allow navigation to any Worksheet, Row or Cell. Created functions to merge cells, and to allow text wrapping.