Page 1 of 1

VBA macro to convert XenForo BBCode to phpBB code

Posted: Tue Nov 15, 2011 5:05 pm
by The Freezer
Here's a VBA macro to have MS Word convert XenForo BBCode to phpBB code. Note: So far, this macro only runs on MS Word.

Submitted as a separate text file since the imbedded BBCodes would make it impossible to post here. But this file is easily imported into the VBA editor: XenForoBB2phpBB.bas

Instructions for importing:
  1. Tools, Macros, Visual Basic Editor (Alt+F11)
  2. In Project box, make sure "Project - Normal" is selected. (This is the default template)
  3. File, Import File (Ctrl+M)
  4. Browse and select the "XenForoBB2phpBB.bas" file
  5. Click "Save Normal" (Ctrl+S)

Re: VBA macro to convert XenForo BBCode to phpBB code

Posted: Tue Nov 15, 2011 5:29 pm
by bphlpt
I didn't realize there was a difference between the two.

Cheers and Regards

Re: VBA macro to convert XenForo BBCode to phpBB code

Posted: Tue Nov 15, 2011 5:58 pm
by The Freezer
bphlpt wrote:I didn't realize there was a difference between the two.

Yeah, it's funny that XenForo takes phpBB code almost verbatim but apparently the reverse isn't true.

Re: VBA macro to convert XenForo BBCode to phpBB code

Posted: Fri Mar 23, 2012 5:26 pm
by The Freezer
Here's how to add a keyboard shortcut for this macro (I use Alt+A in this example).

  1. First from the menubar, click "Tools", select "Customize..." (it's right above "Options").
  2. Then at the bottom of that box click the "Keyboard..." button (it's next to the "Close" button).
  3. Next, in the "Categories" list box, scroll down until you see "Macros" and click on that.
    [img=float-right]http://sstek.vergitek.com/team/docs/AddMacroKeyboardShortcut.jpg[/img]
  4. Select the macro "XenForoBB2phpBB"
  5. Click inside the input box "Press new shortcut key".
  6. Inside here you can press the keyboard combo you want to activate this macro. I've used Alt+A for mine.
  7. The "Assign" button should light up when you're done. Click that and then click "Close".
  8. Now after you copy/paste BBCode from Xenforo, all you have to do is press that keyboard shortcut to convert it to phpBB!