Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have inherited a lot of VBA code to maintain and so far I am using the VBE. Sometimes is quite hard to do some tasks, like advanced text search, so usually I export the module, edit the content with vim and import the modified module to test the code.

This can get a little messy and boring. I know that VBE can be COM automated, so I was thinking if there is a way (like a plugin or a script) to use an external Text Editor (vim, notepad++ or sublime text) to write VBA code and then refresh it automatically in the VBE

Thanks in advance

share|improve this question

2 Answers 2

up vote 3 down vote accepted

AkelPad has VB scripts enabled, so try to ask at Akelpad site about it. Also PSPad has.

share|improve this answer
Thank you, I'll be checking them –  kbsou Jan 23 '13 at 15:49
I made a script to refresh my project and AkelPad worked just fine. Thank you, @Ingo –  kbsou Feb 14 '13 at 11:49
How do I turn syntax highlighting on and choose the syntax language in AkelPad? –  Ivan Aug 21 '14 at 13:17

Sublime Text 2 can work with VBscript as well. You'll need this VBscript Package (github) to access the syntax.

enter image description here

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.