+ Reply to Thread
Results 1 to 6 of 6

URL - Syntax Error (Basic)

  1. #1
    Forum Contributor
    Join Date
    08-28-2012
    Location
    nz
    MS-Off Ver
    Excel 2010
    Posts
    125

    Unhappy URL - Syntax Error (Basic)

    Hi

    Have tried to link cells to URL but as usual i get a "Syntax Error"

    It's all set up just not quite right

    Help appreciated

    Thanks in advance

    Mike
    Attached Files Attached Files
    Last edited by keen2xl; 10-09-2013 at 11:17 AM.

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: URL - Syntax Error (Basic)

    I think your missing a quotation mark after html.

  3. #3
    Forum Contributor
    Join Date
    08-28-2012
    Location
    nz
    MS-Off Ver
    Excel 2010
    Posts
    125

    Re: URL - Syntax Error (Basic)

    Hi tried putting " in but still all red ?

    Any other ideas

    Cheers

  4. #4
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: URL - Syntax Error (Basic)

    sorry, forgot to mention it was missing the underscore at the end of the line as well, should be:
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    08-28-2012
    Location
    nz
    MS-Off Ver
    Excel 2010
    Posts
    125

    Re: URL - Syntax Error (Basic)

    H

    Thanks again tried above code now says "Can not be found"

    So put url in "Get Data From The Web" and that pulls it in so it must be there

    Have quadruple checked values in cells

    " TAUP 10 09 13 01 "

    Meeting Mth Day Yr Race

    Fits in sync wiyh Url construction

    Any ideas : )

    Thanks matey you very Kind

    https://ebet.tab.co.nz/results/TAUP-reslt10091301.html
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: URL - Syntax Error (Basic)

    It's an issue with the web address - if you change the URL in your code to http://www.google.co.uk that works fine.

    For what it's worth, The url there is invalid for me if I try and open it in a web browser.

+ 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. basic macro syntax error..
    By ashish1044 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2013, 05:11 AM
  2. [SOLVED] My some basic programms always show syntax error when i run macros
    By syedfahadjalali in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-02-2013, 03:52 PM
  3. Cannot Run Visual Basic Editor Because of a Syntax error
    By ReallyP in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-17-2012, 04:00 AM
  4. Basic macro syntax error. What is wrong?
    By hunsnowboarder in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2008, 04:26 AM
  5. [SOLVED] Basic VBA syntax
    By marcmc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-02-2005, 06:17 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