Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #13  
Old 01-11-2015, 06:39 PM
ptmuldoon ptmuldoon is offline Referencing FieldCodes in VBA Windows 7 64bit Referencing FieldCodes in VBA Office 2013
Advanced Beginner
Referencing FieldCodes in VBA
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Using FieldCodes, AutoText, BuildingBlocks ptmuldoon Word 5 01-02-2015 01:33 PM
Auto referencing SharkAttack Word 5 02-17-2013 07:09 PM
Referencing darksupernova Word 4 11-08-2012 03:37 AM
Multiple referencing SPRITEtoo Word 3 01-29-2012 07:39 PM
Cross referencing maltesedog Word 0 02-13-2009 07:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft