Automated Template Updates

[Steve Scott]

I have a constant need to update views, tables, filters, fields etc in lots
of plans. Rather than doing this one at a time via organiser, I tried to
record a macro that would automate it, however it needed to know the name of
the current file being updated. Is there a way I can either specify a batch
of names upfront and it updates the plans as a batch or at least via a user
input box to specify the name of the next file after it has finished updating
each one?

 

[John]

I have a constant need to update views, tables, filters, fields etc in lots
of plans. Rather than doing this one at a time via organiser, I tried to
record a macro that would automate it, however it needed to know the name of
the current file being updated. Is there a way I can either specify a batch
of names upfront and it updates the plans as a batch or at least via a user
input box to specify the name of the next file after it has finished updating
each one?

Steve,
I depends on how the code is structured. And yes, the filenames can be
automated in the code or as a minimum, a user input box can be
presented. This isn't something that can be picked up by simply
recording a macro however, it will require the recorded code to be
"tweaked" or better still, written to work in background mode rather
than in foreground mode as all recorded macros work.

John
Project MVP