View Single Post
 
Old 01-11-2015, 06:39 PM
ptmuldoon ptmuldoon is offline Windows 7 64bit Office 2013
Advanced Beginner
 
Join Date: Sep 2014
Posts: 93
ptmuldoon is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
It doesn't sound like you are taking the best approach. I can't work out why you need building blocks at all if you already know how to build the content with code on demand.

Why not simply create a macro that the user can interact with to build the relevant content when they need it? What does the added complexity of building blocks add to the mix?
You just made an excellent point. Since I already know all of the content and can build the code on demand, I really don't need to use building blocks. I'll have to think on setting up a UserForm or similar.

I think perhaps another 'better' approach would be to create a table in excel, and read that info into a multidimensional array in Word. And then possibly have the information available in a dropdown list. The user could then choose their item, and the relevant link code could be added. Something like

Chart Name | Link Code
Monthly Sales | { LINK ....blah blah }


I should have some free time tomorrow in my office to experiment. I'm not the strongest in working with arrays, but I'll start reading up more on them.
Reply With Quote