+ Reply to Thread
Results 1 to 4 of 4

HTML Code on a VBA | Compile Error

  1. #1
    Registered User
    Join Date
    10-04-2013
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2010
    Posts
    19

    HTML Code on a VBA | Compile Error

    Hi All,

    I am trying to put this html code (generated online),
    Please Login or Register  to view this content.
    Into this code under strbody. I was able to resolve the first line, however, I keep getting "compile error expected line number or labelor statement or end of statement". I really have no idea how to proceed.
    Please Login or Register  to view this content.
    Edit: I've already tried doubling the " sign inside the code.
    JCANLAS

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,445

    Re: HTML Code on a VBA | Compile Error

    It's going to be something like:

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    10-04-2013
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: HTML Code on a VBA | Compile Error

    Thanks TMS!

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,445

    Re: HTML Code on a VBA | Compile Error

    You're welcome. Thanks for the rep.

+ 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. code generating compile error: syntex error
    By sankarsasmal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2013, 05:29 AM
  2. [SOLVED] What is wrong with this code? Compile error etc
    By ExcelFailure in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-30-2013, 08:18 AM
  3. [SOLVED] Compile Error in Hidden Module and Compile Error: Can't find project or library
    By Taislin in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-10-2013, 07:03 PM
  4. Compile Error in VBA Code
    By andrewc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-22-2011, 06:49 AM
  5. VB code - compile error box help!!!
    By excel.xls in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2007, 10:15 AM

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