Banner Image

All Services

Programming & Development

Acess/Excel VBA Programming

$5/hr Starting at $25

I have been programming in Access and Excel since the 1990’s.  I am very comfortable with Access (and Excel) and can make it do anything my clients need it to do. I write advanced VBA code for behind the forms and reports as needed.  I have written Access applications that link with other applications like Outlook, Google Docs, Quickbooks and more. I use an Access/Excel application myself to manage my business and to manage my life.  I have several other clients that I have written their main business application as well, all in Access. You can read about my background on my website: http://www.kohlerp.com Some recent projects include: ·         A Time and Billing System for a Law Firm. ·         A Project Management System for an Engineering Department. ·         A Custom Order Entry system for a Manufacturing Company with interfaces to Quickbooks. ·         Some advanced Excel VBA code to interface with other systems and generate email updates for certain events. ·         Access and Excel User Form applications to enter data and generate Word documents and update spreadsheets and tables. ·         Access code to open website data and read results into tables. ·         Wrote Excel VBA with API connection to Trader Workstation 4.0 to read live quotes and update a historical sheet on a user definable interval. ·        Merged several large spreadsheets with data coming in from a variety of sources. ·        A Bar Code Data Collection System for a Manufacturing Plant. ·        A Word VBA form for a Law Firm. ·        An Excel form for to quote custom stair specifications. ·        An Excel form for for a firm that collects and reports on Employee Satisfaction Surveys.

About

$5/hr Ongoing

Download Resume

I have been programming in Access and Excel since the 1990’s.  I am very comfortable with Access (and Excel) and can make it do anything my clients need it to do. I write advanced VBA code for behind the forms and reports as needed.  I have written Access applications that link with other applications like Outlook, Google Docs, Quickbooks and more. I use an Access/Excel application myself to manage my business and to manage my life.  I have several other clients that I have written their main business application as well, all in Access. You can read about my background on my website: http://www.kohlerp.com Some recent projects include: ·         A Time and Billing System for a Law Firm. ·         A Project Management System for an Engineering Department. ·         A Custom Order Entry system for a Manufacturing Company with interfaces to Quickbooks. ·         Some advanced Excel VBA code to interface with other systems and generate email updates for certain events. ·         Access and Excel User Form applications to enter data and generate Word documents and update spreadsheets and tables. ·         Access code to open website data and read results into tables. ·         Wrote Excel VBA with API connection to Trader Workstation 4.0 to read live quotes and update a historical sheet on a user definable interval. ·        Merged several large spreadsheets with data coming in from a variety of sources. ·        A Bar Code Data Collection System for a Manufacturing Plant. ·        A Word VBA form for a Law Firm. ·        An Excel form for to quote custom stair specifications. ·        An Excel form for for a firm that collects and reports on Employee Satisfaction Surveys.

Skills & Expertise

Microsoft AccessMicrosoft ExcelProgrammingVBA

0 Reviews

This Freelancer has not received any feedback.