So Rubberduck lets you write unit tests for your VBA code. If you’re learning VBA, or if you’re a seasoned VBA developer but have never written a unit test before, this can sound like a crazy useless idea. 1,305 more words
Tags » Vba
Run-time error ‘3704’ Operation is not allowed when the object is closed.
To resolve the error, ensure the code you execute returns only data as a result, and not the intermediary “rows affected” messages. 219 more words
Visual Basic for Applications (VBA) is a powerful language that’s available to Microsoft Office users. It can be used to automate various tasks ranging from data cleansing and operations to more sophisticated database connectivity and application development. 461 more words