Results 1 to 9 of 9

Thread: QR Codes for Excel 2003 XP

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #9
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,954
    Location
    Since vbCR = decimal character 13 = hex D or &HD
    and
    vbLF = decimal character 10 = hex A or &HA
    vbCRLF = decimal characters 13 and then 10.

    xld was close. We just need to escape those characters for html.
    "%0D%0A"

    e.g.
    [vba]Sub Test2_DownloadQRcode()
    DownloadQRcode "Hello World!" & "%0D%0A" & "by Kenneth Hobson", "c:\temp\HelloWorld.png", 360
    Shell "cmd /c ""c:\temp\HelloWorld.png"""
    End Sub[/vba]

    Use the Post method if you need to submit more than a 2k URL. https://google-developers.appspot.co.../docs/overview
    Last edited by Kenneth Hobs; 08-03-2012 at 09:03 PM.

Posting Permissions

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