Navigation Bar

HOME  |   ABOUT ME  |   MERM-8  |   DISNEY VILLAINS  |   VIDEO GAME MEMORIES  |   OTHER WORKS

Quote Generator



Friday, March 14, 2014

Writing Macros for OpenOffice


Hey, guess what I did? I converted my Word Macros into OpenOffice, so now you can use them with your favorite free alternative to Microsoft.

Actually, I recommend these macros over the Word ones, as there are various improvements to the coding. They're not as fast as Word's (but nothing in OpenOffice is as fast as Word), but I think they work a little better.

One thing to note: a lot of these macros use the OpenOffice's highlighting function (A.K.A. character back color). For some reason, this doesn't play well with Word's highlighting function. So if you open a document in OpenOffice, highlight stuff, then open it in Word, it's hard to get rid of/clear the highlighting.

How to Install
  1. Open up OpenOffice Writer or LibreOffice Writer (which I use).
  2. Go to Tools->Macros->Organize Macros->OpenOffice Basic
  3. Expand My Macros->Standard->Module 1
  4. Click "Edit"
  5. Copy and Paste the content of standard.bas into the Macro editor. Ctrl+S to save.
  6. Go back to Tools->Macros->Organize Macros->OpenOffice Basic
  7. Highlight "My Macros" and click "Organizer"
  8. Click the "Libraries" tab
  9. Click "New" to create a new library
  10. Name it "Private"
  11. Click "Edit"
  12. Copy and paste the content of private.bas into the Macro editor. Ctrl+S to save.
And that's it! Let me know if you find any bugs or issues by emailing me or leaving a comment.
Post a Comment