VISUAL BASIC PROGRAMMING 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.
|