|
|
|
Results and cost savings are the main considerations when automating Office applications with VBA. The most elegant program that arrives late will take a back seat to an expedient solution that works when needed without involving the 'IT Guy'. Here is a collection of my hard-earned performance tips over the years!
Excel VBA
General VBA Tutorials
Functions
Other
Security
Sound
Web
- Getting started with VBA automation
- How to comment blocks of VBA code In Visual Basic Editor
- Beyond VBE: Visual Studio Code Editor
- VBA Development Best Practices
- How to Optimize VBA Performance
- Sheet Codenames explained
- Μissing VBA Project references
- How to display foreign characters in Visual Basic Editor
Functions
- How to to Remove Excel Tab Colors With VBA
- How to copy strings to Clipboard using Excel VBA
- How to change keyboard language with VBA
Other
Security
- How to add Trusted Publishers in Excel using a digital certificate
- Why 'Project is unviewable' error is shown
Sound
Web
- Websraping: Enable / Disable 'Show Pictures' in Internet Explorer using VBA
Extend VBA With Ribbon Commander
PowerPoint VBA
Office VBA Development Resources
|
Sign up for our Newsletter! Join thousands of Excel professionals who receive exclusive updates for free add-ins, time-saving tips, Lab-X news & access to our members area. Please click here!
|
