![]()
Welcome to Add-Innovation. Construction of this site has been suspended for several years while we've concentrated on consultancy in SAS, MS/Office and VBA. This has strengthened our knowledge and experience.
Now we're back. We're still in consultancy but more recently have been diverting time to learning new skills and packages. We will be enhancing this web-site with many MS/Expression Blend improvements, updating (and enabling) our add-ins to work under Office 2010, and even adding a development blog to "Skeletons in Wellingtons" !
We've pushed our integration of MS/Office applications even further than before, and will be adding details of that development to this store.
For example, a recent development saw replacement of FOCUS programs and laborious process notes, with a one click mainframe SAS to Excel approach. The SAS application presented the feeds one a single page with a start date selection. One click crunched & emailed the mainframe data to the clients MS/outlook account. A VBA macro behind outlook recognised the email and opened an index to determine how to deal with the attachment. The index would show where to store the attachment (adding a link in the email and removing the attachment from the mail), and which macro controlled spreadsheet to open to process it. The mail was tidied away to a history folder.
Add-Innovation specialise in Information Technology Design and Programming. Our main areas of expertise lie in SAS Programming and Application Design, Visual Basic for Applications, and Microsoft Office Applications, with over 20 years of commercial experience. The mix of these skills is extremely useful in rapidly developing low maintenance, highly integrated office solutions utilising the best features of the tools on your desktop.
We've also experience in Ab Initio programming, coupled with "shop for data" taking their product beyond data transform & load operations. Our experience with dozens of other programming languages, platforms and operating systems coupled with a wide scope of business experienced leaves us well positioned to analyse your requirements and design the optimium solution.
Please note that this is an evolving site, starting with the Excel Add-Ins and Excel help section. Please be patient while the remaining sections are developed. Click on the header to go to the index section for each area.
|
|
|||
| VBA Applications,
Excel Usage & Formula Tips, Excel Applications. Examples ;
|
Hints, Tips, and
Resources for VBA,
Design tips, Applications in ;
|
SAS Programming Tips,
SAS Applications, Design recommendations, SAS 4GL, SAS A/F, Maintenance free applications, Reduce, Re-use & Recycle SAS Tools, Macro & Datastep Windows ODS |
Ab Initio coding
techniques,
Hints and Tips, Design suggestions, Resources. |