mathes
asked on
tool request: VBA source code formatter/beautifier
Hi experts,
I am looking for a source formatter which helps me to format my VBA macros.
This tool should meet the following requirements
* no more expensive than 25 USD/EUR
* it should support both Excel and Winword and Access
* it should be a stand-alone executable, not an Add-In.
I would like to add a menu-item to MS Office and start the formatter by a keyboard hotkey.
Do you know such a tool?
I am looking for a source formatter which helps me to format my VBA macros.
This tool should meet the following requirements
* no more expensive than 25 USD/EUR
* it should support both Excel and Winword and Access
* it should be a stand-alone executable, not an Add-In.
I would like to add a menu-item to MS Office and start the formatter by a keyboard hotkey.
Do you know such a tool?
ASKER
Hi again,
thank you very much for your links which lead me to source code formatters.
After visiting the links I found out that these formatters are actually bound for
Visual Basic. I know that VBA and VB are very similar, but not identical.
Can you please tell me, if these VB formatters will be able to format VBA sources properly, too?
thank you very much for your links which lead me to source code formatters.
After visiting the links I found out that these formatters are actually bound for
Visual Basic. I know that VBA and VB are very similar, but not identical.
Can you please tell me, if these VB formatters will be able to format VBA sources properly, too?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi there,
thank you very much for your help. This is exactly what I was looking for.
thank you very much for your help. This is exactly what I was looking for.
personally i use a VCS from www.windsweptsoftware.com but that's more a tool for VB projects although you could also use it in your VBA projects
maybe this one is more what you're looking for
http://www.psiprograms.com/FormatVB.html
and if you want some more choices then this link provides some more
http://www.programmersheaven.com/zone1/cat596/
HTH:O)Bruintje