VBA-IDE-Code-Export icon indicating copy to clipboard operation
VBA-IDE-Code-Export copied to clipboard

Code "formatter" to fix whitespace issues

Open mattpalermo opened this issue 8 years ago • 0 comments

There are a few different "whitespace errors" that are introduced to the VBA when the code is imported (and exported?). Issues #22 and #45 are two of these whitespace errors.

I have also recently experienced a whitespace error where a trailing space will be added to line 2 of a form module. This is the line that looks like this:

Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} MyFormName

To solve these problems, the code should be run through a "formatter" on import (and on export?). It is important that this formatter is non-destructive. I think it would be best to only do enough manipulation to fix the whitespace errors and not get carried away with an other formatting.

mattpalermo avatar Feb 21 '17 03:02 mattpalermo