4 ms·
This has gotten a lot better with the internet. Almost everything in VBA can be found with a simple Google search, and Microsoft's technical documentation onli
by Pasorrijer 6y ago
This has gotten a lot better with the internet.
Almost everything in VBA can be found with a simple Google search, and Microsoft's technical documentation online has gotten very good.
- kgwgk 6y agoIn the dark offline ages there were also those things called "books" :-) https://www.oreilly.com/library/view/vb-vba/1565923588/ https://www.oreilly.com/library/view/vb-vba/1565923588/
- sokoloff 6y agoIt wasn’t the VB part of VBA that wasn’t well documented, but rather the “for A” part that was spotty. The application automation model wasn’t as thoroughly documented as most of Microsoft’s stuff. This was well after the Internet was seriously prevalent. Things like destroying [iff present] and recreating Excel charts from scratch, including generating all the series labels, shapes, etc., updating elements in a word doc from an excel sheet, generating on-slide progress indicators in PowerPoint.
- kgwgk 6y agoThat’s true. But the ability to record macros, as you mentioned, and the object browser alleviate the problem at least in part.