Glenn Ray
Excel VBA Developer
  • Houston,
  • Texas,
  • United States
Member Since: 2011/09/13
Top Skills:
Tech Certifications:
View All
Genius

Provide a quick, creative biography in 140 characters or less.

More bio
Activity
Points this month88
Total points1,566,039
Questions: 5
Solutions: 934
Articles: 1
Videos:
Courses:
Posts:
Group Discussions: 1
Professional Background
No Professional Background shown
More
Education
No Education Background shown
More
Full Biography

**2014 EE Annual Expert Awards**
Microsoft Excel Spreadsheet Software:  Most Points, Most Assist Points, Most Answered
-------------------------------------------------------------------------------------------
BASIC was my first computer language.  And even though I would pick up COBOL, Fortran, Pascal, and even some assemblers, I always returned to BASIC.  My first professional job involved writing code using InfoBasic on a Pr1me computer (I may be dating myself, there).

I got my start writing macros for Lotus 1-2-3 and was hooked immediately by the possibilities of automating spreadsheet work.  It would be a few years, however, before I got my hands on Excel 97 and began coding VBA.

Ever since, I've made a profession out of automating and integrating the Microsoft Office Suite of products.   I've tackled some interesting technical requests:
*  a custom Outlook email form and automated Excel report that retrieves the form data weekly
*  a time reporting system for over 900 employees using Excel and SQLServer
*  a standardized Word template for engineering documents with automated layout solutions
*  an award-winning, multi-variable pricing system for resellers of over 3,000 products

But, I get my biggest reward out of saving people time.  I routinely am asked to automate manual tasks and very often, can cut the processing time by more than 75%.  It's great when a user - who may spend a couple of hours on a Sunday afternoon manually creating an Excel workbook due Monday morning - only has to call up a single macro and create the same report in seconds.  Which, of course, means that they can do it on Monday while they're settling in at the office.

And while I enjoy helping other people here at EE, I have to say that I've learned more from the participation here than in any other environment.  The questions have pushed my skills further also, and I get a kick out of discovering a solution to a problem I didn't know I had! :-)

-Glenn


More
Languages
No Languages shown

Level Progress

Current: Level 27
Glenn needs 1,961 points to level up.
LVL 28
  • Overall
    27
  • Microsoft Excel
    26
  • Spreadsheets
    10
  • Microsoft Office
    9
  • VB Script
    8
  • Visual Basic Classic
    7
  • Microsoft Applications
    7
  • Office / Productivity
    7
  • VBA
    5
  • Office Suites-Other
    3
  • Microsoft Access
    3
  • Microsoft Development
    3
  • Programming
    3
  • Microsoft Word
    2
  • Visual Basic.NET
    2
  • Math / Science
    2
  • Microsoft SQL Server
    2
  • Query Syntax
    2
  • Software-Other
    2
  • Outlook
    1
  • Google Apps
    1
  • Algorithms
    1
  • Scripting Languages
    1
  • Microsoft Legacy OS
    1
  • Citrix
    1
  • Microsoft PowerPoint
    1
  • Programming Languages-Other
    1
  • Windows Batch
    1
  • Windows OS
    1
  • Databases
    1
  • DB Reporting Tools
    1
  • HTML
    1
  • Project Management
    1
  • WordPress
    1
  • Windows 7
    1
  • Microsoft SharePoint
    1
  • Active Directory
    1
  • Dell
    1
  • LibreOffice
    1
  • Microsoft Dynamics
    1
  • Microsoft SQL Server 2008
    1
  • Office 365
    1
  • Oracle Database
    1
  • Powershell
    1
  • SQL
    1
  • Sybase Database
    1
  • Web Development Software
    1
  • iOS
    1

Profile Validation

Email Verified
Expert Level Achieved