General macro for running other macros on batches of files?

Nomey · Guest

Hi There,

Does anyone know where I could find a snippet of code that executes another Sub in the same Module om a batch of Word files?

Or a macro that executes any other macro (user selected) on a batch of Word files?

Best regards,
Shirley

Google · Sponsor

fumei via OfficeKB.com · Guest

As to the first question, you can execute another Sub by Calling it. In fact,
it is a good general idea to do exactly that. Break longish code into
multiple Subs, and Call them. The other Subs can have input arguments.

It is a good idea to do this, as it makes debugging chunks of code MUCH
easier. It also makes reading thing easier, as you are dealing with logical
chunks.

Sub DoLots()
Dim strIn As String
Dim oBM As Bookmark
' yadda yadda...some stuff
' giving value to the string
' setting a bookmark
' WHATEVER

Call DoOtherOne (strIn, oBM)
Call DoSomethingElse
End Sub

Sub DoOtherOne(strBlah As String, ThisBookmark As Bookmark)

' do something with strings and bookmarks

End Sub

Sub DoSomethingElse()

' lots of other crap
End Sub

As for question #2, user selected macros. You could certainly take a user
selected string, and make that a variable, then pass that to the Run method.

Look up the Run method in Help.:

Nomey wrote:

fumei via OfficeKB.com · Guest

Sorry, but if you are asking HOW to execute action on a number of files, that
is a different thing.

Use the Dir function. It works well.

--
Message posted via http://www.officekb.com