2

Is there any program or website that could convert an Excel macro code into an html nice looking format.

I used syntaxhighlighter for Java and Java scrtipt. Is there anything similar fot Excel?

CHEBURASHKA
  • 1,623
  • 11
  • 53
  • 85
  • 1
    Syntaxhighlighter has `shBrushVb.js` which should work for VBA macros. Not sure if it handles formulas though. – Dave Rager Jul 30 '13 at 20:20
  • I'm guessing it will handle formulas okay and +1 it makes sense to use a tool that you are already comfortable with. However, using another syntax-highlighter shouldn't be too tricky, as they tend to be quite similar. – Andy G Jul 30 '13 at 20:31

2 Answers2

5

Check whether syntaxhighlighter recognises VBScript; this is more likely than a specific mention of VBA and almost identical for highlighting purposes. (Just checked, it mentions Visual Basic and VB.NET, so you can continue with syntaxhighlighter - which seems sensible.)

highlight.js mentions VBScript, and has an example, but I haven't used it myself.

In fact, I think most syntax-highlighters will show a reasonable representation of VBA code.

Andy G
  • 19,232
  • 5
  • 47
  • 69
2

You should check Notepad++, which supports several languages (VB included).

Qiu
  • 5,651
  • 10
  • 49
  • 56
  • 2
    This is not what the OP is looking for. He wants to display the code embedded in, most likely, a web-page, so needs a tool that will take the script and wrap it in HTML tags. – Andy G Jul 30 '13 at 20:29