Results 1 to 2 of 2
  1. #1
    5 Star Lounger st3333ve's Avatar
    Join Date
    May 2003
    Location
    Los Angeles, California, USA
    Posts
    705
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Settings for recording macros (Word 2002 SP-2)

    As noted in my post from yesterday, I have a homemade dialog that I use to select Word macros for running and editing.

    I'd love to be able to use it to record macros as well. That is, it would be great if, when I typed the new macro's name in the text box and hit the Record button (i.e., the Record button in my dialog), Word would do the following:

    1. Open my global macros template, if it isn't already. (Like most of us, I believe, I'm putting my macros in their own separate template.)

    2. Change the location for the recorded macro to the global macros template.

    3. Start recording the macro with the already-active document (not the macros template) as the active document.

    VBA can certainly handle Step 1, but how about Steps 2 & 3? (If the answer is "SendKeys," please don't tell me about it unless you have personal glitch-free experience using SendKeys for this purpose.)

    Alternatively, is there a setting I can tweak (Registry or otherwise) to handle Step 2?

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Settings for recording macros (Word 2002 SP-2)

    Regarding Nos. 2-3, the online help for Word 2002 VBA, Built-in Dialog Box Argument Lists, says:

    wdDialogToolsMacroRecord (This dialog box cannot be called from a macro.)

    (A macro that "clicks" the menu choice using CommandBars.FindControl(ID:=2780).Execute also returns an error.)

    This suggests that you might have to implement any macro recording feature using a separate program (e.g., COM Add-in) rather than a standard macro.

    After you turn off recording to the (currently non-global) macros template, you'll have to clear out the code for switching back to the previously active document.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •