VBA macro to convert XenForo BBCode to phpBB code

Miscellaneous tools
User avatar
The Freezer
Posts: 351
Joined: Sun Aug 29, 2010 2:19 pm
Location: Northeast Ohio
Has thanked: 2 times
Been thanked: 5 times
Contact:

VBA macro to convert XenForo BBCode to phpBB code

Postby The Freezer » Tue Nov 15, 2011 5:05 pm

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)
I would love to change the world, but they won't give me the source code.

Link:
BBcode:
HTML:
Hide post links
Show post links

User avatar
bphlpt
Site Admin
Posts: 64
Joined: Fri Oct 29, 2010 6:09 am
Has thanked: 5 times
Been thanked: 2 times

Re: VBA macro to convert XenForo BBCode to phpBB code

Postby bphlpt » Tue Nov 15, 2011 5:29 pm

I didn't realize there was a difference between the two.

Cheers and Regards
Image

Link:
BBcode:
HTML:
Hide post links
Show post links

User avatar
The Freezer
Posts: 351
Joined: Sun Aug 29, 2010 2:19 pm
Location: Northeast Ohio
Has thanked: 2 times
Been thanked: 5 times
Contact:

Re: VBA macro to convert XenForo BBCode to phpBB code

Postby The Freezer » Tue Nov 15, 2011 5:58 pm

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.
I would love to change the world, but they won't give me the source code.

Link:
BBcode:
HTML:
Hide post links
Show post links

User avatar
The Freezer
Posts: 351
Joined: Sun Aug 29, 2010 2:19 pm
Location: Northeast Ohio
Has thanked: 2 times
Been thanked: 5 times
Contact:

Re: VBA macro to convert XenForo BBCode to phpBB code

Postby The Freezer » Fri Mar 23, 2012 5:26 pm

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!
I would love to change the world, but they won't give me the source code.

Link:
BBcode:
HTML:
Hide post links
Show post links


Return to “Other Tools”

Who is online

Users browsing this forum: No registered users and 0 guests