Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-03-2021, 03:46 PM
Guessed's Avatar
Guessed Guessed is offline Generate document from templates and user variables - Field, Property, BBlock or Mapped Control Form Windows 10 Generate document from templates and user variables - Field, Property, BBlock or Mapped Control Form Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default


I wouldn't use fields and bookmarks. I would use Content Controls instead. With those content controls, I would also probably map them to a custom XML file. A solution might involve a library of language/masthead specific XML files which could be substituted into the file to implement the changes.

I would not create three separate userforms - the same userform should do language, masthead and data fields in one action.

As to your Challenges/Limitation/Questions
1) Can building block contains fields/bookmarks? Yes they can but it is easier and cleaner to use mapped content controls
2) We have 120 mastheads per language, can the building block.dotx support that large number of data? Yes they can but if you are going to multiply this by 6 for each language, I would recommend you put each language set in a different template/addin and load the required one only.
3) Since I am calling directly the masthead using in VBA after entering the template code, am I not better using InsertFile instead of building block (this will prevent me asking user to go in their AppData to do changes or to have to load all blocks data in the master template). I don't understand this question, you must be distributing the template(s) to the users somehow already so why would this be a problem?
4) I can't use third party macro such as Graham Mayor addins Bummer dude! Yet you ask third parties for advice on this forum. Does this mean we can't provide you code samples or advice? You are welcome to recreate all this functionality from scratch - it's not my time or money you are spending to do so
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #2  
Old 09-06-2021, 05:10 AM
TheBigBoss TheBigBoss is offline Generate document from templates and user variables - Field, Property, BBlock or Mapped Control Form Windows 7 32bit Generate document from templates and user variables - Field, Property, BBlock or Mapped Control Form Office 2010 32bit
Advanced Beginner
Generate document from templates and user variables - Field, Property, BBlock or Mapped Control Form
 
Join Date: Dec 2016
Posts: 56
TheBigBoss is on a distinguished road
Default

Thanks for your reply Guessed.

Ahahaha, I know it's a bummer but what can I do? We have strict policies.

I shall indeed try to start from scratch... this said, it does not prevent you from assisting nor sharing codes, if required, as I am here unofficially

I will report back on progress made and post any challenges I face if any.

Thanks a lot
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Possible to create a user form and populate it with a field from the main document? NMGMarques Word 3 02-12-2020 06:08 PM
Generate template-based letter with multiple variables shallaes Word VBA 5 07-12-2018 12:18 AM
Generate document from templates and user variables - Field, Property, BBlock or Mapped Control Form Content Control Field Names/Titles Word Form shammi_raj Word VBA 3 03-10-2016 02:54 AM
form control Field - Drop down auto text mrtinfl Word 5 11-19-2014 06:57 AM
Use document property as condition in IF field? ChrisBrewster Word 2 01-29-2014 10:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:51 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