Hi Richard,
It is possible probably to automate the unblocking & merge process via a macro, but unless the data file is saved with the same path & filename, the process will fall over. It is also possible to use a macro to pull data directly from a web page, but that may be a bridge too far. Ultimately, the question is one of where and how much do you move the complexity from the user to the programmer. I'm all for making things as simple for the user as practicable, hiding the complexity in the code, but that means you may be creating an on-going maintenance task for the programmer (eg websites change, file names & locations change, someone upgrades the OS/network and that impinges on things, etc).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|