Did you find something
helpful on my site? Consider a donation!
Heeft u iets gevonden waar u wat aan had? Overweeg dan een donatie!
What can we do for you?
JKP Application Development Services develops custom-made applications, using
Microsoft Excel and VBA to its full
extent. Since the products are customer specific and often under NDA, there are no downloadable
examples on this site.
Applications may range from relatively simple repetitive task handling
utilities to full fledged applications.
There are no restrictions to your type of business. The application to be
developed can concern any discipline or profession, e.g. financial, chemical
engineering, data modelling, statistical, medical, etcetera.
To get an impression of some of the available expertise, a few examples of utilities developed by the owner are to be found
on our download pages.
Shell EP Netherlands: Develop a set of templates which are used to update
project planning models. The Excel templates are downloaded from a SAP portal
and use SAP Webservices to (securely) pull data from and push data to SAP XI.
Essent trading : Developing various Excel (VBA) tools for the Energy
trading desk, supporting traders with their Excel related issues.
ABN AMRO bank the
Netherlands (Risc Managment): Developing various complex rapporting systems
(Excel + VBA + Lotus Notes automation) and a switchboard Application (MSAccess)
to run these automatically.
For Fortis
Netherlands: Assisting with a migration project from Win NT/Office 97 to WinXP/Office
2003. Analysis of hundreds of thousands of files for potential migration
issues, using a customised Access application. Fixing issues during the
migration.
NavigatorXL: Wizards for
uploading data to and downloading data from Oracle systems directly from
within Excel.
For Weka publishers: professionalise a
system to create annual social reports.
For the Dutch Ministry of Social Affairs: a course on Advanced Excel VBA.
Topics: Class modules (backgrounds, custom events, collections). Userforms
(Create on-the-fly using code, add code programmatically, add controls at
runtime, create control events using class modules). Add-ins (COM, VB6) in
Excel. Smart Tags. Controlling Outlook and Word via Excel VBA. Creating and
modifying databases and tables using ADO and SQL.
For Shell Brands International AG, a system to enter and analyse global
advertising campaign pre-test research data (using VBA, Pivot tables, Data
Validation and conditional formatting).
For a UK waste management company: updating a graphing package that is
used for the analysis of nuclear waste streams (using extensive VBA coding).
A reporting system for an American company with which they calculate the
weekly pay and bonuses for their technicians and which reports their sales over
various periods of time. The project involves Excel and VBA programming, using
Microsoft ADO to extract data from an Access database.
For an American financial consultancy company: A system to import email
messages from Outlook into Excel in order to be able to process the name and
address data (entered in a webform) from people subscribing to a newsletter.
This project involved programming Outlook from Excel, using VBA from within
Excel.
JKP Application Development Services.
Subscribe in a reader