So I am dedicating today’s post to those struggling with their doubts on whether to open up the VBE (Visual Basic Editor). From time to time I see some Excel macro that does the job of a Excel PivotTable or more often that of a simple MS Query (SQL). Reason being is often that some of us don’t know, or better still, don’t make the minimal effort to learn ready available tools in Excel or other Office applications. VBA) is often misused causing issues with maintaining code, backward compatibility with older Excel version and other issues.
0 Comments
Leave a Reply. |