Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 04-11-2018, 09:47 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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


You're welcome. However, please don't quote every post you reply to - all that does is add clutter. If there's a particular part of a post you need to discuss, quote just that part.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #17  
Old 04-12-2018, 03:24 AM
slaycock slaycock is offline Windows 7 64bit Office 2016
Expert
 
Join Date: Sep 2013
Posts: 256
slaycock is on a distinguished road
Default

Maybe I've misunderstood.

If you toggle the visibility of the ingredients then that text is still present when the document is sent to a freelancer. Thus the ingredients text may be viewed and /or corrupted by editing done by the freelancer.

With my macros you create your source document with the ingredients then before you send to a freelancer you run my macros to convert the ingredients text to an include text field.

When the freelancer receives this document, the include text fields will show as an error because the ingredients source documents are not present on their system. This makes it safer for the freelancer to edit the document without touching the broken includetext field.

When you get the edited document back, you place it in the same directory as the original document and then do a select all and F9 to update the document. This will reload all of the ingredient files.

You can emulate this process by copying your recipe document to a different directory. When you open the document to edit it you will see the include text fields showing an error. Edit the document avoiding changes to the includetext fields, save under a new name, copy back to the original directory, open the document and refresh it as described above, and the include text fields will again show the ingredients.

Once you have finished with the freelancers editing the document and you are ready to use it further for the publishing process, you select the whole document and do a control+F( to convert the include text fields back to text.
Reply With Quote
  #18  
Old 04-12-2018, 04:56 AM
liliaroma liliaroma is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Nov 2017
Posts: 14
liliaroma is on a distinguished road
Default

@slaycock Thanks for your really awesome idea! If the idea runs successfully, it is very safe for me to send the file for freelancers.

I followed your instructions but when I copy the recipe document to a different directory, the include text fields did not show as an error. I recorded my working process in the following video. I really hope you will see it and give me some recommendations. Thanks a lot.

Video: https://youtu.be/yBxfzfL-RK0
Reply With Quote
  #19  
Old 04-12-2018, 05:14 AM
slaycock slaycock is offline Windows 7 64bit Office 2016
Expert
 
Join Date: Sep 2013
Posts: 256
slaycock is on a distinguished road
Default

That's because I made recommendation without thinking clearly.

The includetext fields are setup using an absolute path. This means that if you just move to any other directory on your PC it will still work. APologies for that bad (recommendation, not the file path).

Instead try the original file on a second PC and you will see what I intended.
Reply With Quote
  #20  
Old 04-12-2018, 05:36 AM
liliaroma liliaroma is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Nov 2017
Posts: 14
liliaroma is on a distinguished road
Default

Sorry, but I tried on another PC and it did not show the include text fields as an error. I attached a new file that I run your macro. Please download it for taking a look on it.
Attached Files
File Type: zip 15 Recipes.zip (252.2 KB, 11 views)
Reply With Quote
  #21  
Old 04-12-2018, 08:48 AM
slaycock slaycock is offline Windows 7 64bit Office 2016
Expert
 
Join Date: Sep 2013
Posts: 256
slaycock is on a distinguished road
Default

OK, so some form of metadata is preserved. Before you send your document to a freelancer, open it on a different PC, update the fields and then save the document. This should ensure that the includetext fields just show the error message.
Reply With Quote
  #22  
Old 04-12-2018, 01:54 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Quote:
Originally Posted by slaycock View Post
When the freelancer receives this document, the include text fields will show as an error because the ingredients source documents are not present on their system.
That's not necessarily so; it all depends on whether the recipient has the 'Update automatic links at open' option checked.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #23  
Old 04-12-2018, 08:24 PM
liliaroma liliaroma is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Nov 2017
Posts: 14
liliaroma is on a distinguished road
Default

Thanks both @slaycock and @macropod for the great support. Now, I have 2 solutions for my problem and I am very thankful about this.

For the solution of @slaycock, I only need to delete or rename the folder included Ingredient sections. And then, the include text fields will show as an error.

For the solution of @macropod, I can solve my problem easily and quickly with one click.

I strongly believe that I will use both of them for my task because they are awesome.
Reply With Quote
  #24  
Old 04-13-2018, 02:29 AM
slaycock slaycock is offline Windows 7 64bit Office 2016
Expert
 
Join Date: Sep 2013
Posts: 256
slaycock is on a distinguished road
Default

Quote:
I only need to delete or rename the folder included Ingredient sections. And then, the include text fields will show as an error.
<blushes> Sometimes we can't see the wood for the trees.
Reply With Quote
  #25  
Old 04-13-2018, 04:25 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Re slaycock's approach, you can suppress the error message by embedding the INCLUDETEXT fields in IF fields that test for the error. For example:
{IF{INCLUDETEXT "{FILENAME \p}/../ingredients_1.docx"}<> "Error*" {INCLUDETEXT "{FILENAME \p}/../ingredients_1.docx"}}
Note that the above code assumes the ingredient files are kept in the same folder as the file they're linked to - the field coding employs the Relative Path linking described in http://www.msofficeforums.com/word/3...nal-files.html. If you're not keeping them in the same folder, simply edit the field code to suit.

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find instances of heading text in the body of my doc, make cross reference to the actual heading MAHE Word VBA 4 03-03-2018 07:59 AM
How to delete automatically 500 “Heading 4” and all the contents in this from Navigation? liliaroma Word VBA 4 11-18-2017 07:53 PM
How to Hide/Un-hide a worksheet based on cell on another sheet. easton11 Excel Programming 1 06-02-2015 12:07 PM
Creating a table that automatically updates based on entries of a heading in the document cahphoenix Word 3 10-29-2014 01:11 PM
How to have a heading 1 file automatically appear in each header of any page? expert4knowledge Word 2 09-16-2012 10:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:18 PM.


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