+ Reply to Thread
Results 1 to 17 of 17

need help to convert links to QR

  1. #1
    Registered User
    Join Date
    10-09-2018
    Location
    ksa
    MS-Off Ver
    2016
    Posts
    17

    Question need help to convert links to QR

    i have a large text in WORD file , and in between there are some links
    i need a VBA to replace the links with QR photo
    thanks a lot if that's possible..

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: need help to convert links to QR

    Word 2010 doesn't support QR codes. Word 2013 & later do, however, without the need for VBA - simply use an appropriately-formatted DISPLAYBARCODE field.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    10-09-2018
    Location
    ksa
    MS-Off Ver
    2016
    Posts
    17

    Re: need help to convert links to QR

    hey macropod , im sorry to ask , but how i can use that?

  4. #4
    Registered User
    Join Date
    10-09-2018
    Location
    ksa
    MS-Off Ver
    2016
    Posts
    17

    Re: need help to convert links to QR

    i have a lot of links in one word file , i want to convert them all , do i have to do it each link separate
    or there is a way to do it all at once

    thanks a lot

  5. #5
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: need help to convert links to QR

    Your profile says you're using Office 2010. As I said, though, Word 2010 doesn't support QR codes.

  6. #6
    Registered User
    Join Date
    10-09-2018
    Location
    ksa
    MS-Off Ver
    2016
    Posts
    17

    Re: need help to convert links to QR

    No im using 2016

  7. #7
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: need help to convert links to QR

    Yes, but your profile (which you've now updated) said Office 2010. Since you're actually using Office 2016, see: https://msdn.microsoft.com/en-us/lib...ffice.12).aspx

  8. #8
    Registered User
    Join Date
    10-09-2018
    Location
    ksa
    MS-Off Ver
    2016
    Posts
    17
    Yes I updated 2010 to 2016 , i didnt noticed before , anyway the method you suggested for me i know about it i just need a little help to use it in a macro to apply it to all the links i have in the text automatically (VBA)
    If that would happened it will be so great to do ...
    Last edited by abdullabf; 01-11-2019 at 03:58 PM.

  9. #9
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: need help to convert links to QR

    Perhaps:
    Please Login or Register  to view this content.

  10. #10
    Registered User
    Join Date
    10-09-2018
    Location
    ksa
    MS-Off Ver
    2016
    Posts
    17

    Re: need help to convert links to QR

    yessss thanks a lot, you are life saver ...

  11. #11
    Registered User
    Join Date
    10-09-2018
    Location
    ksa
    MS-Off Ver
    2016
    Posts
    17

    Re: need help to convert links to QR

    hi macropod,
    the shape of QR its not an image ,
    it would be more better if its an image not just a shape i cant copy , if i paste it to an email or share it it goes back to codes !
    can you help me to do it, im really thankful

  12. #12
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: need help to convert links to QR

    The use of field coding is the only way Word creates QR barcodes. If you want, you could copy the barcode then paste it into your email using Paste Special the picture option (i.e. EMF - enhanced metafile).

  13. #13
    Registered User
    Join Date
    10-09-2018
    Location
    ksa
    MS-Off Ver
    2016
    Posts
    17

    Re: need help to convert links to QR

    using Paste Special the picture in email its not showing all the text,
    i did try to add something , can i use ".Code.CopyAsPicture
    .Code.PasteSpecial " and if so how to do it , i tried and i had blank result

  14. #14
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: need help to convert links to QR

    I said you paste the QR field as a picture; I said nothing about doing that with text - you hadn't previously even mentioned that you were doing any copying/pasting of text. To replace the hyperlink in a QR barcode image is considerably more complex:
    Please Login or Register  to view this content.
    Last edited by macropod; 01-14-2019 at 09:08 PM.

  15. #15
    Registered User
    Join Date
    10-09-2018
    Location
    ksa
    MS-Off Ver
    2016
    Posts
    17

    Re: need help to convert links to QR

    "run time error '4198':
    command failed"

    I got this message on line ".CopyAsPicture"

  16. #16
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: need help to convert links to QR

    Works for me...

  17. #17
    Registered User
    Join Date
    10-09-2018
    Location
    ksa
    MS-Off Ver
    2016
    Posts
    17

    Re: need help to convert links to QR

    Thanks macropod, you helped me , i’ll find out how to do it ...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to convert text links to hyperlinks?
    By emil9216 in forum Excel General
    Replies: 6
    Last Post: 02-01-2018, 04:31 PM
  2. Remove all Links and convert to General
    By curtiswheat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-02-2016, 03:09 PM
  3. [SOLVED] Convert links to values
    By jomili in forum Word Formatting & General
    Replies: 7
    Last Post: 02-29-2016, 09:27 AM
  4. Convert list of text links into Hyperlinks?
    By jaustin008 in forum Excel General
    Replies: 1
    Last Post: 07-08-2012, 04:14 PM
  5. Convert cells to links
    By vbhal in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-24-2011, 08:34 PM
  6. [SOLVED] Convert external links to internal
    By Marie J-son in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2006, 11:55 PM
  7. How do I convert email addresses to clickable links?
    By Rick Wetzel in forum Excel General
    Replies: 3
    Last Post: 02-05-2005, 03:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1