Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-22-2018, 04:47 AM
rogerbowering rogerbowering is offline Conditional Picture URLs for Logos Windows 10 Conditional Picture URLs for Logos Office 2010 32bit
Novice
Conditional Picture URLs for Logos
 
Join Date: Apr 2017
Posts: 15
rogerbowering is on a distinguished road
Post Conditional Picture URLs for Logos

Hi



I have to produce Word templates for 4 different sections in our business

Many documents are the same differentiated only by the logo that is displayed and it would reduce the number of documents I create if I could dynamically show the correct logo using an IF statement and then picking the correct picture url, http://xxxx.com/image1.png, http://xxxx.com/image2.png

This all needs to be as a Word field!! Not as a VBA module.

So..1. Assuming I can find a criteria to compare "IF..", how would I bring back one of, say, three different logos from urls and place them at the head of the document?

Can pictures also be added with formatting? Size, In Front of Text are the main ones

Thanks
Reply With Quote
  #2  
Old 09-22-2018, 06:19 AM
macropod's Avatar
macropod macropod is offline Conditional Picture URLs for Logos Windows 7 64bit Conditional Picture URLs for Logos Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,369
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

Not going to happen - at least not reliably. Whatever you do with field coding and without VBA, all 4 logos would remain in any document created from the template. What's the aversion to VBA?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-23-2018, 12:28 AM
Guessed's Avatar
Guessed Guessed is offline Conditional Picture URLs for Logos Windows 10 Conditional Picture URLs for Logos Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,159
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

You might want to explore Building Block Content Controls for a drop-down selectable solution that doesn't need VBA.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #4  
Old 09-24-2018, 02:02 AM
rogerbowering rogerbowering is offline Conditional Picture URLs for Logos Windows 10 Conditional Picture URLs for Logos Office 2010 32bit
Novice
Conditional Picture URLs for Logos
 
Join Date: Apr 2017
Posts: 15
rogerbowering is on a distinguished road
Default

Actually, maybe VBA might be an answer if anyone can advise how to code it (please)

Initial aversion is because I using prewritten templates by a supplier and I'm not sure if new VBA will 'break' their code

Didn't understand the building block comment

PS, the document is locked from user editing, hence they wouldn't be able to modify using drop downs (or anything) when they open the document
Reply With Quote
  #5  
Old 09-24-2018, 02:12 AM
macropod's Avatar
macropod macropod is offline Conditional Picture URLs for Logos Windows 7 64bit Conditional Picture URLs for Logos Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,369
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

If "the document is locked from user editing" as you say, it's difficult to see how you're going to add a logo to it. That said, I believe what you're referring to as being "locked from user editing" is the template, rather than the document created from it; perhaps you could check that.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 09-24-2018, 02:16 AM
rogerbowering rogerbowering is offline Conditional Picture URLs for Logos Windows 10 Conditional Picture URLs for Logos Office 2010 32bit
Novice
Conditional Picture URLs for Logos
 
Join Date: Apr 2017
Posts: 15
rogerbowering is on a distinguished road
Default

Hi it's all a little bit complex..

The document template I work with is a pre-built template by our supplier. I populate lots of 'maul merge' type codes into it (they are not mail merge code in actuality but special tags that will get populated two steps on when a user requests a report to be run)
Reply With Quote
  #7  
Old 09-24-2018, 02:21 AM
macropod's Avatar
macropod macropod is offline Conditional Picture URLs for Logos Windows 7 64bit Conditional Picture URLs for Logos Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,369
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

That has no necessary connection with your "the document is locked from user editing" statement.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #8  
Old 09-24-2018, 02:22 AM
rogerbowering rogerbowering is offline Conditional Picture URLs for Logos Windows 10 Conditional Picture URLs for Logos Office 2010 32bit
Novice
Conditional Picture URLs for Logos
 
Join Date: Apr 2017
Posts: 15
rogerbowering is on a distinguished road
Default Bit complex

The document is populated with special tags, then an included VBA script is run to create essentially a HTM version of the document

Which is uploaded to a remote folder

When the system (An online claims system) is being used by a user and want a report, they click a button and the system reconstructs the Word document, but this time with all the field data populated from the system.

The front page of reports (including header/footer/logos) contains auditable information and has to be locked from user editing

There are two bits of Word code in the document currently. One updates the SAVEDATE with 'today's' date and another checks to see if the Filename starts "DRAFT..." and, if so displays DRAFT in a text box behind the report text.

So, these bits of code work and in the locked sections, probably because the document has just been created and saved, which updates the fields

That's why I was hoping the "IncludePicture' field would be more flexible
Reply With Quote
  #9  
Old 09-24-2018, 02:27 AM
macropod's Avatar
macropod macropod is offline Conditional Picture URLs for Logos Windows 7 64bit Conditional Picture URLs for Logos Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,369
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

In that case, I suggest you contact the owners of the system that produces these reports and have them integrate the additional functionality into it. Without access to the documents and the underlying code, I'd be loathe to start developing that would be incompatible with what you already have.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #10  
Old 09-24-2018, 02:33 AM
rogerbowering rogerbowering is offline Conditional Picture URLs for Logos Windows 10 Conditional Picture URLs for Logos Office 2010 32bit
Novice
Conditional Picture URLs for Logos
 
Join Date: Apr 2017
Posts: 15
rogerbowering is on a distinguished road
Default

Paul

Thanks I appreciate your comments. It will probably need to go back to the suppliers, but our first port of call was to see if we could do something ourselves to speed things up; to see if Word itself (and Word fields) could supply what we needed
Reply With Quote
Reply

Tags
conditional, pictures



Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Picture URLs for Logos List of 30 items with Logos, transition the 30 items blexann PowerPoint 1 11-03-2016 08:55 AM
Conditional Picture URLs for Logos Not press F9 to refresh URLs? ASW122 Mail Merge 5 07-14-2014 09:35 PM
Use logos on name badges Stonely Word 6 09-18-2012 08:56 AM
Conditional Picture URLs for Logos URLs in citations acappella Word 3 07-24-2012 03:28 PM
Move Picture by picture name, rename picture by picture name CatMan PowerPoint 2 04-18-2012 12:21 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:01 PM.


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