Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-14-2018, 11:46 AM
Ironic Ironic is offline Open url image with dynamic generated html (from cell) in Word Windows 7 32bit Open url image with dynamic generated html (from cell) in Word Office 2013
Novice
Open url image with dynamic generated html (from cell) in Word
 
Join Date: May 2018
Posts: 5
Ironic is on a distinguished road
Default Open url image with dynamic generated html (from cell) in Word

Hi all.

My objective is to have a cell in the document where I enter a value.
This value is to be concatenated to a html link (that corresponds to an image).
Then i would like to display that image.



This seems to be possible in Excel (with macro) but i would prefer to do it in Word since this is to be done in a properly formatted document.

Anyway of doing this in Word, ideally not in a convoluted way?

(and i mistakenly post this in Excel and not Word section. Any admin please move it)

Thank You
Reply With Quote
  #2  
Old 05-15-2018, 03:38 AM
macropod's Avatar
macropod macropod is offline Open url image with dynamic generated html (from cell) in Word Windows 7 64bit Open url image with dynamic generated html (from cell) in Word 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

Perhaps you could attach a document to a post with some representative content. You can do that via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-15-2018, 11:43 AM
Ironic Ironic is offline Open url image with dynamic generated html (from cell) in Word Windows 7 32bit Open url image with dynamic generated html (from cell) in Word Office 2013
Novice
Open url image with dynamic generated html (from cell) in Word
 
Join Date: May 2018
Posts: 5
Ironic is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Perhaps you could attach a document to a post with some representative content. You can do that via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
Hello macropod. You mean to add a document here? But i do not know how to do it.

But to give a more pratical example, my objective is to generate QR codes.
So let's say i write 1234 in a cell.
I append the 1234 to this html string:https://api.qrserver.com/v1/create-q...&data=wxy.com/
I get this link https://api.qrserver.com/v1/create-q...a=wxy.com/1234
Which is the QR code to the desired site:

This way each time i change the number in the cell the QR code would update in document.
Reply With Quote
  #4  
Old 05-15-2018, 04:17 PM
macropod's Avatar
macropod macropod is offline Open url image with dynamic generated html (from cell) in Word Windows 7 64bit Open url image with dynamic generated html (from cell) in Word 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 Ironic View Post
You mean to add a document here? But i do not know how to do it.
I told you how in the very content you quoted...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 05-17-2018, 11:17 AM
Ironic Ironic is offline Open url image with dynamic generated html (from cell) in Word Windows 7 32bit Open url image with dynamic generated html (from cell) in Word Office 2013
Novice
Open url image with dynamic generated html (from cell) in Word
 
Join Date: May 2018
Posts: 5
Ironic is on a distinguished road
Default

Lots of confusion here.

I meant i did not have a document to share here because i did not know how to even start a document to to this.

Excel is doable, but not in Word as far as i know

Regards
Reply With Quote
  #6  
Old 05-17-2018, 02:53 PM
macropod's Avatar
macropod macropod is offline Open url image with dynamic generated html (from cell) in Word Windows 7 64bit Open url image with dynamic generated html (from cell) in Word 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 could create a hyperling field with a FILLIN field nested within, thus:
Code:
{HYPERLINK "https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=wxy.com/{FILLIN "QR String"}"}
To do this:
• Type
Code:
https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=wxy.com/
into the document, then press Enter. Word will create the hyperlink with the full address displayed.
• Right-click on the hyperlink and choose 'Edit Hyperlink', to give the hyperlink a name that tells the user what to do (e.g. 'Select then press F9 to update')
• Press Alt-F9 to expose the field code, which will look like:
Code:
{HYPERLINK "https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=wxy.com/"}
Then, before the final ", insert a FILLIN field coded along the lines of:
{FILLIN "QR String"}
Then press Alt-F9 again to toggle the field code display off.

From now on, if you select the hyperlink and press F9, as per the hyperlink display text, you'll get a pop-up asking for the QR string. If you input that, then click on the hyperlink display text, you'll be taken to the page displaying that QR code.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 05-18-2018, 09:04 AM
Ironic Ironic is offline Open url image with dynamic generated html (from cell) in Word Windows 7 32bit Open url image with dynamic generated html (from cell) in Word Office 2013
Novice
Open url image with dynamic generated html (from cell) in Word
 
Join Date: May 2018
Posts: 5
Ironic is on a distinguished road
Default

Tks for your help but i was looking for a more automated way of doing it.

I guess Word it just not suited for this. I will stick with Excel.

Thank you for your help macropod

Regards
Reply With Quote
  #8  
Old 05-18-2018, 03:27 PM
macropod's Avatar
macropod macropod is offline Open url image with dynamic generated html (from cell) in Word Windows 7 64bit Open url image with dynamic generated html (from cell) in Word 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

Perhaps you could explain what you mean by 'more automated'? Word supports macros, etc., the same as Excel does.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 05-22-2018, 07:30 AM
Ironic Ironic is offline Open url image with dynamic generated html (from cell) in Word Windows 7 32bit Open url image with dynamic generated html (from cell) in Word Office 2013
Novice
Open url image with dynamic generated html (from cell) in Word
 
Join Date: May 2018
Posts: 5
Ironic is on a distinguished road
Default

Hello macropod

What i mean is that in Excel this can be done by simply writing to a cell.

My concern if that the users will forget to run the macro. With Excel that concern does not exist.

Regards
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
dynamic image in template Mackswel PowerPoint 0 01-10-2017 09:27 AM
Open url image with dynamic generated html (from cell) in Word Word 2010 doesn't open HTML-files properly Cepreu Word 3 06-22-2015 02:40 AM
Open url image with dynamic generated html (from cell) in Word Image Quality When Saving Word Document as HTML amos Word 2 01-22-2014 02:45 PM
Open url image with dynamic generated html (from cell) in Word Outlook Web Access: How to load the "Microsoft Dynamic Html Editing Control" Add-On? tomtom67 Outlook 1 08-31-2009 12:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:58 AM.


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