View Single Post
 
Old 04-05-2013, 03:38 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,359
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote