Professional Excel VBA Developer
Hi, I often work on very complex projects and design solutions that are easy to use with Custom Templates, Ribbon Tabs and highly structured clean code. Many of these applications are highlighted in my portfolio below.
I’ve studied Object Oriented Programming for 18 years and developed VBA macros in Excel for the last 12. I cannot emphasize enough how important objects and structured programming are when developing in Excel. VBA macros can quickly become very large and extremely complicated, creating a tangled mess nearly impossible to upgrade and debug; even by the original designer. I believe the use of OOP’s and structured code is essential, even when designing small Excel/Word VBA applications.
I specialize in event driven Add-Ins and user interface design with easy to use ribbon tabs and panels. I am also highly skilled in designing user forms and fast and efficient code using Excel’s advanced functions.
I also maintain a large library of class modules, related user forms and ribbon configurations. This allows me to drop-in very complex and refined functionality which can dramatically reduce the overall project hours, often providing functionality and features that would otherwise be too time consuming.
I am skilled in generating MS Word reports from Excel and Ribbon Tab design using XML/VBA. I’ve worked with Think or Swim and Sterling Trader Pro using Excel (DDE) add-ins for real-time stock data. I am also experienced with Yahoo Finance –Yahoo Stock Quote API (CSV)
Expert Area: Microsoft Excel, Microsoft Word, VBA, PDF Conversion, Spreadsheets, Data Scraping, Data Analytics, Visual Basic, Yahoo! Store