Skip to main content
A
Anonymous
September 27, 2006
Answered

automate macro in output

  • September 27, 2006
  • 1 reply
  • 752 views
Hello all,

I have two macros, presently on buttons on the toolbar, that I run on the generated word output to:

- Re-format to house standard (bits lost in translation from RH)
- Remove extra spaces in hidden text (index entries) to reduce the size of the file (circa 13%).

What I am trying to achieve is for the macro to run as soon as the output has been generated. Can this be controlled via RH?

When this project comes to an end, there will be 2 people left to maintain all of the documents, and I would like to make life as easy as I can for them.

Thanks

Brian
This topic has been closed for replies.
Correct answer Peter Grainge
I don't think this can be achieved as a macro has to manually started, as you do now, or something has to trigger it. Normally that will be opening any file or a specific file. You clearly do not want the macro to run when you open any Word file so a macro has to exist within the Word file containing the RH output. Clearly that cannot exist so I cannot see any way of doing what you want.

The best Word forum I know of is at www.wopr.com and click the link to Woody's Lounge. If you explain you want a macro to autorun on completion of a document being created by another application, you might find one of the gurus there has an idea. They are a very helpful and very clever bunch of guys.

1 reply

Peter Grainge
Community Expert
Peter GraingeCommunity ExpertCorrect answer
Community Expert
September 27, 2006
I don't think this can be achieved as a macro has to manually started, as you do now, or something has to trigger it. Normally that will be opening any file or a specific file. You clearly do not want the macro to run when you open any Word file so a macro has to exist within the Word file containing the RH output. Clearly that cannot exist so I cannot see any way of doing what you want.

The best Word forum I know of is at www.wopr.com and click the link to Woody's Lounge. If you explain you want a macro to autorun on completion of a document being created by another application, you might find one of the gurus there has an idea. They are a very helpful and very clever bunch of guys.

Use the menu (bottom right) to mark the Best Answer or Highlight particularly useful replies. Found the answer elsewhere? Share it here.
A
Anonymous
September 27, 2006
Thanks for the quick response Peter.

I didn't really think I could control it via RH, but one lives in hope.

Thanks Again

Brian
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices