WoodApps - Home

About

I have been programming for over 20 years.

I am experienced in:

PC Application Creation
Web Development (Client and Server Side)
Microsoft Office Document Automation (VBA)
Microcontroller and PLC programming
Networking Design and IT Services
System Administration
Scripting and app package creation

Unlike a lot of programmers I have worked in a variety of industries over the years. As a result I have a very good understanding of the requirements of my customers. I have good communications skills and I am able to work with my customers to accurately interpret their needs.

I am currently a senior systems administrator for a large global IT company, primarily creating computer policies and automation scripting. The job pays the bills but I don't get to do the creative hands-on work that I really enjoy, which is why I started this business. Designing programs for people allows me to work on a variety projects, apply my skills, and most importantly have the satisfaction of helping people solve their problems.

Services

I provide custom programing and IT consulting services.

When it comes to programming, there are countless programming languages and areas of specially. Currently I am focusing on System Administration, Scripting, Web Apps (social media sites, database work, mapping programs... ) & Microsoft Office using Visual Basic for Applications, Power BI, but on occasions do I design custom desktop apps and provide other computer services.

Although I do work on large projects, I enjoy working on little jobs as well. If you have a small Excel macro you want added, a quick inventory program created, or need a question answered, I will squeeze it in.

Just tell me what you would like done and I will provide a response as soon as possible.

Questions are always welcomed.

Contact Now!

VBA and Microsoft Excel

VBA (Visual Basic for Applications) is a programming language typically used with a number of Microsoft Office Applications. By integrating VBA into these applications you can do far more than make simple recorded macros. You can do pretty much anything.

For example, it can be used to design better user interfaces, allow for automation, or allow the application's data to be shared with other Office applications. The majority of my work involves Excel, but VBA can be used with many other Microsoft Applications as well.

VBA User Interfaces:

With VBA you can design Input Forms and Display Windows.
You can use:

Buttons
Tabs
Input Boxes
Check Boxes
Option Buttons
etc

In the case of Input Forms, data could be entered, checked for accuracy and then automatically inserted into your document or processed in any number of ways.

If needed, we can lock down the worksheet so that data can ONLY be entered via these forms.

User Names, Passwords, hidden Sheets... anything is possible with VBA.

VBA Automation:

With the use of conditional statements and loops a programmer can automate tasks. Repetitive steps and even complicated decision-making can be repeated over and over, thousands of times in a second.

If you have large amounts of data that needs to be processed, or you receive additional data on a regular basis, having a program created to process this data can be very helpful.

Even a standard user can make macros, but pre-recorded macros can only do so much. With a VBA program created you can do almost anything with just a click of a button.

One common form of automation that I do is write programs to scan through massive amounts of data, extract information, and then format it in a useful manner.

In the example above the raw data is in the form of plain text, possibly from a pdf file. This data is scanned, keywords are located, data is automatically extracted, verified and inserted into the correct columns of an Excel Worksheet.

Interaction between Office Applications:

Do you need to copy all of your contacts from Outlook to Word or Excel, and then format them in some particular way? Or maybe only certain contacts depending on some specific criteria. A VBA program can be written to bridge the gap between the Applications.

Whether you have a large job in mind, or just want a simple macro created... Send me an email. Tell me what you are wanting to do and I will quickly give you a quote.

Have a question?
Ask now!

Web Apps

Websites

are a collection of individual webpages found on a domain. This domain is called woodapps.ca. The webpage you are currently viewing is called index.html. It and several other linked pages make up the business section of my website.

Typically modern webpages designed with a responsive layout which means they change their size and formatting to fit the device they are displayed on. Computer, Tablet, Smart Phone etc

Usually professional website designers manually create websites using the standard programming languages (HTML / CSS / JAVASCRIPT). These websites can be designed to look and behave however the programmer and customer sees fit, providing the most flexibility in website design.

On the other hand for some basic websites, sometimes people use premade templates found in website builders usually available through a web hosting service. These are acceptable but typically the layout can't be modified very much. I can help with either option.

There are pros and cons with either option which we can discuss. Regardless of which method is used, new sites can be designed, or existing sites can be modified.

Web Apps

are a little different. Information on a standard website is typically be pretty static. For example: Services Provided, Menus, The Business's Address and Contact Information etc. Web Apps on the otherhand are not just visual, they are more interactive and there is a lot more programming in the background. The App will include features such as shopping carts, user accounts, animations, games, message boards etc. As a result a lot more programming goes into designing a Web App.

A Web App is different from an App you might find on your phone because it is not specific to a certain type of device. An Iphone App downloaded from the Apple App Store can only be used on an IOS device. A Web App is just an advanced Website. It doesn't need to be downloaded and it doesn't matter if you are on a computer, an Samsung or an Iphone.

With Web Apps, in addition to the programming languages mentioned before with standard websites, web apps use different technology including server side programming languages and SQL databases. When it comes to these custom applications, it is designed entirely by a programmer from scratch. html php