VBA PROGRAMMING SKILLS
Microsoft Office
 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.
Here are some examples of the software created in Microsoft Visual Basic for Applications:-
Microsoft Access Database Programming
- Created a Component Object Module (COM) interface to allow third party access, using
VBA, Microsoft Word and Microsoft Excel, to the records on the Microsoft Access
database on the Server.
- Supported a Microsoft Access database which contained the rules for a data driven
Client/Server system.
- Converted a DAO Jet Engine to an ADO database module using Visual Basic for Applications.
Converted the relinking of a backend Access database from DAO to ADO.
- Using Visual Basic for Applications, supported an Asset Valuation database written
in Microsoft Access which included substantial work both in developing automation
applications for both Microsoft Word and Microsoft Excel.
- Porting and redevelopment of a Sales Analysis application to a Microsoft Access
Database, using Visual Basic for Applications.
- Amended and enhanced the Microsoft Access database Rostering system for the Sydney
Opera House using Visual Basic for Applications.
- Amended and enhanced the Corporate Express Cataloguing Microsoft Access database.
- Using Visual Basic for Applications, created correlation functions for City Rail's
accident analysis (SPAD) Microsoft Access database.
- Designed and created a Microsoft Access database for the University of New South
Wales, using Visual Basic for Applications to handle the automation of Prospectus
mailing from their Web site.
- Using Visual Basic for Applications, created a Microsoft Access database for Singles,
featuring a compatibility algorithm for matching couples. It includes data entry
from a Web Site and automated Access database updating from Microsoft Outlook emails.
- Created an automated payment system for Independent Practitioner Network (IPN),
which handled the submission of doctors' fees to Westpac. An ADO Recordset was created
from an Access Query, and payment details extracted for each doctor. There was provision
for manual adjustments and balancing before submission to the bank.
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 for Masterton Homes. See the Visual Basic page.
Microsoft Outlook Programming
- Developed an Email Reply application using Microsoft Outlook and Microsoft Visual
Basic for Applications. A ComboBox 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.
|