#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
Quote:
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. |
#4
|
||||
|
||||
I told you how in the very content you quoted...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
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 |
#6
|
||||
|
||||
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"}"} • Type Code:
https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=wxy.com/ • 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/"} {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] |
#7
|
|||
|
|||
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 |
#8
|
||||
|
||||
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] |
#9
|
|||
|
|||
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 |
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 |
Word 2010 doesn't open HTML-files properly | Cepreu | Word | 3 | 06-22-2015 02:40 AM |
Image Quality When Saving Word Document as HTML | amos | Word | 2 | 01-22-2014 02:45 PM |
Outlook Web Access: How to load the "Microsoft Dynamic Html Editing Control" Add-On? | tomtom67 | Outlook | 1 | 08-31-2009 12:23 AM |