AWE - LIGHTNING FAST, LOW-CODE SPREADSHEET MACROS THAT ALLOW BEGINNER TO ADVANCED DEVELOPERS TO FOCUS ON SOLVING THEIR BUSINESS PROBLEM RATHER THAN THE COMPLEXITIES OF EXCEL. AWE handles the basics of interfacing with the spreadsheet so that you can focus on solving your business problem with as few lines of code (low-code) as possible. AWE contains free open-source, fully documented, Excel Macros that automate Excel functionality so that beginner to advanced macro programmers can write lightning fast macros with minimal code. 

AWE Includes:

  1. LIGHTNING FAST PROCESSING – Fast processing on small to large (one million plus row) spreadsheets
  2. Easy to Use - Implement a few lines (low-code) of fully documented AWE code that will simplify and shorten your macros
  3. Open-source – Import macros that perform basic to complex spreadsheet functionality
  4. Low-Code – Focus on solving your business problems with just a few lines of code
  5. Dynamic Sheets – Change the order of columns and rows without rewriting macros
  6. FREE - Open-source code that you can evaluate, import into your workbook, and start using now

AWE_Array - Lightning Fast Excel Worksheet Macros

16 May 2023 11:41

Update spreadsheets with blazing fast speed. Use arrays to easily write and update thousands of rows at sub-second speeds. Easily convert ranges (congruent, non-congruent or filtered) to arrays, use column headers and row values to find and update data and then write the array back to the sheet. Don’t wait another second for your macros to finish processing. Go from time consuming, complex data search and updates to lighting fast performance with just a few lines of code. AWE_Array only requires a few lines of code to implement. Best yet, it’s FREE.  

Read more »

AWE_Email - Create and Read Emails

9 May 2023 18:02

AWE_Email handles the complexity of creating and reading MS Outlook Emails. This includes creating emails with Excel Charts, PivotTables, Ranges, and attachments. Easily create complex search criteria that finds and reads email. Interface with MS Exchange and Outlook to lookup contacts. All source code is included and it's FREE.

Read more »

AWE_SHEET - Easily Find Ranges, Columns, Rows, and Cells

8 Mar 2023 16:02

AWE_Sheet removes the complexity of finding, retrieving, and updating data in your spreadsheet that would otherwise require Named Ranges, a Table, or a dozen lines of code. AWE_Sheet is packed with macros that allows you to quickly find, retrieve, and manipulate data on your sheet with just a few lines of code so you can more easily focus on the business problem. AWE_Sheet extends Worksheet functionality allowing you to continue using Excel's great interface, i.e., AutoFilter, SpecialCells… Best yet, all source code is included (see the below implementation section for the code) and it’s FREE.  

Read more »

AWE_PivotTable - Update PivotTables and Slicers

6 Feb 2023 16:19

Seamlessly update Slicer and PivotTable Cache throughout your workbook with or without using Tables. WE_PivotTable does away with the complexity of Syncing multiple PivotTables and Slicers in just one call that updates Slicers and PivotTable Caches.  

Read more »

Check Back For Upcoming Blogs

Check back for when the following blogs become available...

  • Integration with Digital.ai Agility (VersionOne) - Automatically download VersionOne (Planning Levels, Epics, Stories, Tasks...) to your Spreadsheet using REST Queries and DOM. 
  • Drag and Drop Outlook Email to Excel- Drag and Drop Outlook emails to a row on your Spreadsheet and do something with it.  
  • Integration with Microsoft Power Automate - Run Excel Macros using Microsoft Power Automate. 
  • Query SharePoint Lists - Import data from  SharePoint Lists.
  • Create Dynamic Dashboards - Automatically update dynamic dashboards to show current status.

Register now to receive emails when these and more blogs become available!