+ Reply to Thread
Results 1 to 2 of 2

Run time error 424: object require - Extract data using API

  1. #1
    Registered User
    Join Date
    06-18-2020
    Location
    Malaysia
    MS-Off Ver
    2016
    Posts
    1

    Run time error 424: object require - Extract data using API

    Hello everyone,
    I am working on the VBA code to extract the data from website using API link. i trying to use regex to scoop out the portion for exchange rate for usd_sgd & jpy_sgd_100 into same worksheet in cell B2 & C2. I try to use if else then statement for 2 different pattern "usd_sgd" and "jpy_sgd_100". After i run the code, it compile error "Run time error 424 object require" on line:For Each match In matches. I just wanted to extract exchange rate data for "usd_sgd" and "jpy_sgd_100" from the same API link into same worksheet in cell B2 & C2 after run the code. I am appreciate someone can guide me on this. Thank you in advance!

    VBA code as per attached.
    Attached Files Attached Files

  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,336

    Re: Run time error 424: object require - Extract data using API

    Well, first, I wouldn't use match as a variable name, given it's an Excel function.

    Step through the code ... there's nothing in matches.
    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


+ 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] Getting error 424 object require
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2017, 03:35 AM
  2. [SOLVED] Run-time error 424 object require
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-12-2016, 10:51 PM
  3. Object require error
    By noobsesher in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-04-2016, 04:56 PM
  4. [SOLVED] Getting run-time error 424 object require
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-28-2015, 01:15 PM
  5. Getting error 424 object require
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2014, 12:06 AM
  6. [SOLVED] Getting error 424 object require
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-09-2014, 04:53 AM
  7. [SOLVED] object require error
    By necalabria in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-26-2012, 08:46 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