This repository holds examples of using stdVBA
. This should give people a better idea of how to use stdVBA
and libraries.
Title | Type | Short Description | Tags | Dependencies | Status |
---|---|---|---|---|---|
Accessibility Inspector | DevTool | Inspect the accessibility information of controls UI controls. Critical for UI automation. | ui, window, automation, embedding,simple | stdAcc, stdProcess, stdWindow, stdICallable | Deprecated |
Accessibility Inspector v2 | DevTool | Inspect the accessibility tree of windows. Critical for UI automation. | ui, window, automation, embedding,advanced | stdAcc,stdCallback,stdClipboard,stdICallable,stdImage,stdLambda,stdProcess,stdShell,stdWindow | Complete/WIP |
JSON Viewer | DevTool | Inspect JSON data in a userform. | json, viewer, browser,advanced | stdCallback, stdICallable, stdJSON, stdLambda, tvTree | Complete |
A registry viewer for VBA | DevTool | Inspect information in the registry without the need for regedit access. | registry, win32, viewer, browser,advanced | stdClipboard, stdIcallable, stdLambda, stdReg | Complete |
Clipboard Inspector | DevTool | Inspect information in the system-wide clipboard. | clipboard, text, image, binary | stdClipboard | Complete |
Running Object Table Inspector | DevTool | Inspect information in the system-wide Running Object Table. | component, object, model, COM, running, object, table, ROT | stdCOM | Complete |
Automate the web with Chrome | Library | Automate major browsers for web scraping or UI presentation. | web, automation, accessibility, library | stdAcc, stdEnumerator, stdLambda, stdProcess, stdWindow, stdICallable | Complete |
Create documents based on tabular data | Data Utility | Build a userform dynamically to make changes to an input object. | automation, data, document, generator, library, table,advanced | stdCallback, stdCOM, stdEnumerator, stdICallable, stdLambda, stdRegex, stdTable, stdWindow | Complete |
Dynamically Userform Example | Library | Build a userform dynamically to make changes to an input object. | User,Interface,UI | stdUIElement, stdCallback, stdCOM, stdICallable, stdLambda | Complete |
Macro Dispatcher | DevTool / AdminTool | Define exactly which macros should be run in which particular order across multiple spreadsheets. Monitors success and errors. | macro, scheduler, dispatcher, bulk, automation, data, process,advanced | stdAcc, stdCallback, stdEnumerator, stdICallable, stdLambda, stdPerformance, stdReg, stdWindow | Complete |
Notepad GetAllTextAndClose Utility | Utility | Get all text from all open Notepad tabs and close them. Useful when you use Notepad for note taking. | notepad, utility, automation, data, extract | stdAcc, stdICallable, stdLambda, stdProcess, stdWindow | Complete |
Split windows side by side | Productivity Utility | Split your excel window in half for increased productivity. | window, automation | stdLambda, stdWindow, stdICallable | Complete |
Bulk Spreadsheet Extractor | Data Utility | Extract information from multiple structured Excel documents to a table. Includes version differentiation. | data, extract, bulk | stdArray, stdCallback, stdCOM, stdEnumerator,stdICallable, stdLambda, stdPicture, stdRegex | Complete |
Further SQL-like table operations and class for handling all things table powered by stdEnumerator | Library | A sql-like system for handling Excel ListObjects. | sql, listobject, table, update, select, database | stdICallable,stdEnumerator,stdCallback,stdJSON | Complete |
Timer | Library | Call code at set intervals. | timer, time, stopwatch, watch, poll | stdCallback, stdICallable | Complete |
Embed Microsoft Word into a userform | UI Control | Present text to users as a Microsoft Word control. | ui, window, automation, embedding | stdLambda, stdWindow, stdICallable, stdProcess | Complete |
Excel Application helper | Library | Make getting the Application object easier, and extend it with additional methods. | application, ebmode, edit, mode, LPenHelper | stdAcc, stdICallable | WIP |
Excel custom save handler | Library | Custom Excel save handler with more events. | save, handler, custom, events | None | Complete |
Excel sql-like table operations | Library | A sql-like system for handling Excel ListObjects. | sql, listobject, table, update, select, database | stdICallable | Complete |