Need VBA solution for autotext replacement like Phrase Express or Robotype
Posted on 2014-01-05
I want a custom text expansion/autotext function for my Microsoft Office applications. I can't load outside programs such as PC Magazines Robotype, to my work computer because of IT policy. However, I do have VBA available.
I'd like to develop an autotext function with vba. I know about the Word function for this task but I don't like how it's implemented. I'd like a separate database for custom text expansion or boilerplate text expansion rather than having my custom stuff mixed in with the Word stuff.
I was thinking about an array of my custom abbreviations with replacements. Better yet, the array would read from an Access table.
The trigger would be that when the spacebar is pressed after a defined autotext element/record, the replacement text would be typed immediately rather than completing a document and doing a find/replace. This is how RoboType works.
I am willing to learn some VBA to do this, I need to know some general concepts as to how to get this done and then figure out the details as I go.