Macro to write a macro

[aschaak]

I've written a macro that processes seven reports every day. My bosses have asked me to set up a macro that adds to the original macro when new reports become available. In other words, a macro that creates a macro.

If nothing else, I figure I can create a blank script in Word, an input box to capture the individualization provided by the user, and then import it as a module into the macro.

But I was hoping somebody might have a better idea.

Please?

 

[JLGWhiz]

I've written a macro that processes seven reports every day. My bosses have asked me to set up a macro that adds to the original macro when new reports become available. In other words, a macro that creates a macro.

If nothing else, I figure I can create a blank script in Word, an input box to capture the individualization provided by the user, and then import it as a module into the macro.

But I was hoping somebody might have a better idea.

Please?

I think I would question what the boss is asking. The description does not make much sense.

 

[L. Howard]

I've written a macro that processes seven reports every day.

How about posting the macro you have written?
And tell what & why & where & for it needs to be added to.

Howard