Questions About Workspace Macro Pro

[pdalton]

I more or less stumbled onto a reference about Workspace Macro Pro, which led me to this website, where I also read about the amazing capabilities of Automation Anywhere. But AA's really too expensive for me to purchase for macros that I only use personally at work and at home, so I'm curious about whether WMP can help meet my needs.

1. I have one REALLY long MS Word macro (~3000 lines) that I use just about every day. Almost everything posted on the web uses only a single space after the period at the end of a sentence. My macro changes that to 2 spaces after each period -- an easy change that creates a troublesome result: There just are a lot of words, abbreviations, etc. where there should be only one space after the period. So the bulk of this macro is search/replace sequences, each correcting the improper double spacing after the period for an individual word, abbreviation, etc. As I find new ones, I add them and -- over the years -- that's how this macro has gotten so big. So:

A. Does WMP have the capability to import this macro and/or to optimize it?

B. Would WMP be capable of adding an easier way to add new items to the search/replace list in the macro?

2. Where does WMP store its macro code? I know that regular MS Word macros are stored in Normal.dot, which can create a problem when it gets too much "macro baggage."

3. If I create a macro using WMP, will I be able to copy and use that macro on my computer at home? If so, how?

Thanks,
Paul

[forumsupport]

Hello,

Regarding your queries,

1) You can create a macro to automate the search process using Macro Editor. Unfortunately, you cannot import word macro into Macro Editor of Workspace Macro Pro. However, you can run word macro from Workspace Macro pro by assigning shortcut key to word macro and playing that shortcut key using Keystrokes command.

You can add search/replace list in an excel file and repeat the macro for every search item using Repeat property. At the end of macro just move the cursor to next search item in excel so that on every repeat next item would be processed. In that way, in case you want to add a new search item then you just have to add the search/replace item in an excel file.

Is it possible for you to send us sample word file, search/replace list and steps to process the task so that we can create a sample task for you.

2) Default location of macros (.wksp file) is under, 'C:\...\My Documents\Workspace Macro Pro\My Macros' folder.
If your macro is very large then you can also create multiple macros and chain them together using 'Run Macro' command.

3) Yes, but Workspace Macro Pro is required to be installed on your home PC in order to run .wksp file. To use same macro on home PC, you just have to copy paste the macro under default location, 'C:\...\My Documents\Workspace Macro Pro\My Macros' folder

Hope that helps.